Error: Authentication method '' is not supported.

victor-wiki / DatabaseManager

A simple tool for databases : SqlServer, MySql, Oracle, Postgres and SQLite

125 stars 48 forks source link

Error: Authentication method '' is not supported. #13

Open duanyunlun opened 3 months ago

duanyunlun commented 3 months ago

QQ_1722417608318

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 commented 2 months ago

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.