MySQL8.0 - [ERROR] unknown variabledefault-authentication-plugin=mysql_native_password

Application issues
1

I am using MySQL Server v8.0.37 with application that only uses legacy authentication method mysql_native_password so the database is setup this way.

When I run your software to test connection to the MySQL Server I get the error popup MySQL80 test failed. mysql: [ERROR] unknown variable 'default-authentication-plugin=mysql_native_password.

I cannot seem to find a setting on your software to connect using a legacy authentication password method.

Your software has been around for some 15 years and well before they started to use the SHA256 password method so it must be able to support legacy mode somehow.

I hope you can help.

2

Dear Mario_Nicotra,

In order to address the issue at hand, kindly provide the path to your bin folder in the advanced connection settings.

SQLBackupAndFTP
SQLBackupAndFTP584×551 18.4 KB

If you have any other inquiries, please do not hesitate to inform us.

We appreciate your understanding and apologize for any inconvenience caused.