Error: Authentication method '' is not supported.

[duanyunlun]

Environment: 1, MySql version : 4.0.18 2, Local ODBC Driver : 3.51.13; 3, Visual Studio : 2022 Enterprise;

I test the connection string (also the user/password) in Navicat, it can connect to the DB, this MySql version is very old so I think maybe your tools not support it.

This tool is a very amazing DB helper for me so I hope there would be a workaround for me to transfer my data from OLD MySql to SqlServer. Thanks!

[victor-wiki]

For mysql, it uses the MySqlConnector, not use ODBC Driver. From the official website, It seems that the version "4.0.18" is not supported. So, you can migrate your database to a mysql server with higher version, then use the tool.