Getting a blank connection error on MySQL data source

Question

Hi,

I recently moved to a new computer and have been setting up my database connections again. My SQL Server connections are functioning correctly, however when I try to connect to a mySQL database, I'm getting a completely blank connection error. Has anyone else encountered this before? The connection functions fine when I test it int the ODBC administrator.

dreldrel · Answer

Try to check if you have set up the connection configuration properly in Alteryx and ODBC Manager (e.g. Database, Role). If this helps, feel free to like the comment

ajinaniyan123 · Answer

I’ve run into this before when setting up MySQL connections in Alteryx Designer x64 after moving to a new machine. A blank “Connection Error” usually points to an ODBC/driver mismatch rather than the database itself. A few things worth checking:

* Make sure you installed the 64-bit MySQL ODBC driver (Connector/ODBC 8.0) since Alteryx Designer x64 won’t read the 32-bit one.

* Confirm the DSN is created under System DSN in the 64-bit ODBC Administrator (C:\Windows\System32\odbcad32.exe), not just under User DSN.

* If your MySQL server is on version 8.0, check the authentication method. Some older drivers don’t support caching_sha2_password, so either switch the user to mysql_native_password or upgrade to the latest ODBC driver.

* Try a DSN-less connection string in Alteryx as a test, for example:

Driver={MySQL ODBC 8.0 ANSI Driver};Server=myserver;Database=mydb;User=myuser;Password=mypass;Option=3; 
* Also worth double-checking SSL settings in the DSN, since missing certs can also throw blank errors.

If the ODBC test works but Alteryx still fails, reinstalling the driver fresh often resolves hidden issues. In rare cases where the database itself has corruption, running CHECK TABLE or using a repair utility such as Stellar Repair for MySQL can help ensure the database is healthy before connecting.

ntobon · Answer

https://knowledge.alteryx.com/index/s/article/Receive-an-error-when-trying-to-connect-to-MySQL-database