Cannot connect to MySQL from Tableau

0 votes
I can't get Tableau to connect to my MySQL server from another machine on the same network. I have WAMP installed on the server, and I can administer the database using phpMyAdmin just fine, but I need to access it from Tableau.

These are some of the mistakes I've encountered:

The ODBC Data Source could not be connected to. Verify that all required drivers are installed and that the connection characteristics are correct. [MySQL] [ODBC Driver 5.3(w)] Your address does not have a hostname.

The server "nick-server" could not be reached. Check that the server is up and operating, and that you have permissions to the database you've requested.

The server could not be reached. Check that the server is up and operating, and that you have permissions to the database you've requested.
Mar 4 in Tableau by Vaani
• 7,020 points
104 views

1 answer to this question.

0 votes
1) Your workstation may have a firewall that allows you to connect to port 80 for phpMyAdmin but not to other ports.

2) If you can ping the second computer (i.e. resolve the machine's name to an IP address and obtain a response), you may use telnet server 3306 to telnet into your MySQL port (3306).

PING localhost (127.0.0.1): 56 data bytes PING localhost (127.0.0.1): 56 data bytes
icmp seq=0 ttl=64 icmp seq=0 ttl=64 icmp seq=0 ttl=64 icmp seq=0 time=0.054 milliseconds 3) Here's an example of a telnet answer from a MySQL server. If you can connect to your MySQL server, you'll probably receive something similar.

$ telnet 3306 localhost
Attempting::1... telnet: connect to address::1: Connection denied
I'm going to try 127.0.0.1...
Localhost has been established.
']' is the escape character.
J
You should be able to connect from Tableau if the methods above work.
answered Mar 10 by Neha
• 8,940 points

Related Questions In Tableau

0 votes
1 answer
0 votes
1 answer

How to access MYSQL Database from tableau?

Hi Sindhu,  1. Double click on Mysql on the ...READ MORE

answered Mar 19, 2019 in Tableau by Cherukuri
• 33,050 points
2,093 views
0 votes
1 answer

How to connect to sap hana database from Tableau?

Hi, Follow these steps to connect to data ...READ MORE

answered Mar 22, 2019 in Tableau by Cherukuri
• 33,050 points
2,072 views
0 votes
1 answer

How to connect to oracle database from Tableau?

Hi, Follow these steps to connect to oracle ...READ MORE

answered Mar 22, 2019 in Tableau by Cherukuri
• 33,050 points
3,972 views
0 votes
1 answer

Can Tableau Reader read workbooks that access their data via a link to a web-exposed server?

Tableau Reader can only access worksheets that ...READ MORE

answered Mar 10 in Tableau by Neha
• 8,940 points
66 views
0 votes
0 answers

Can Tableau Reader read workbooks that access their data via a link to a web-exposed server?

Can Tableau Reader read Tableau workbooks that ...READ MORE

Mar 10 in Tableau by Neha
• 8,940 points
92 views
0 votes
1 answer

How to implement Linked List in Python?

You can use Deque that works better than linked list ...READ MORE

answered Oct 26, 2018 in Python by Priyaj
• 58,100 points
431 views
0 votes
0 answers

Using Python and Tableau in conjunction with one another

Is it possible to mix Python visualisations ...READ MORE

Feb 28 in Tableau by Vaani
• 7,020 points
125 views
0 votes
1 answer

How to upload data to Tableau Server in Python

https://www.tableautim.com/playlist-video/tableau-tds-and-tdsx-files/csv-to-tdsx Then install the tableau-api-lib utility for Python ...READ MORE

answered Mar 4 in Tableau by Neha
• 8,940 points
586 views
0 votes
1 answer

How to scrape a public tableau dashboard?

To extract data from Tableau workbooks, I ...READ MORE

answered Mar 4 in Tableau by Neha
• 8,940 points
404 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP