MySQL test does not work

[mauricev]

I can't get the MySQL test to work using 9.58 and the downloaded copy of LIBMYSQL.DLL. When I try it using the command line tool, the server tells me

Code: Select all

the client does not support the authentication protocol requested by server. 

I'm using MariaDB 5.5.32 (which is binary compatible with MySQL of the same version).

[KS-Soft Europe]

Looks like old authentication type problem.
Solutions:
1. Try to update libmysql.dll library.
2. Reset MySQL password to pre-4.1 style using SQL query like:
SET PASSWORD FOR 'user'@'host' = OLD_PASSWORD('newpwd');
3. Use ODBC Query test instead of "MySQL server check". You'll need to install MySQL ODBC drivers.

[mauricev]

SET PASSWORD FOR 'user'@'host' = OLD_PASSWORD('newpwd');

That worked. Thanks.

[KS-Soft Europe]

You are welcome