I’m attempting to connect Tableau to a remote MySQL database from mac. On Windows, I was able to set this up by installing the ODBC driver and VStudio, and no issues--connection successful.
However, I keep encountering errors on mac when trying to configure or establish the connection despite following instructions and using the drivers on Tableau website.
Any insights would be appreciated.
Hi, in Mac there are two things. If you are using hostname, make sure to use the full qualified name or the ip.
Also, which driver did you installed? I recommend you install the 8.0.33 release of the driver.
If you are using Tableau Desktop for silicon processors use:
https://downloads.mysql.com/archives/get/p/10/file/mysql-connector-odbc-8.0.33-macos13-arm64.dmgIf using Tableau Desktop for intel install this driver:
https://downloads.mysql.com/archives/get/p/10/file/mysql-connector-odbc-8.0.33-macos13-x86-64bit.dmgFinally, you may test with this public mysql:
https://docs.rfam.org/en/latest/database.htmlTo avoid conflicts make sure there is only one driver installed. 8.1, 8.2, 8.3, 8.4 and 9.x release of the drivers may not work.
When it says password none, it means without password.
If this post resolves the question, would you be so kind to "Accept this Answer"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Tableau Ambassador