MySQL test does not work

When you post information about some problem, please include the following details: - OS version (e.g. Windows 2000 Professional SP3); HostMonitor version; problem description.
Post Reply
mauricev
Posts: 2
Joined: Tue Dec 17, 2013 3:51 pm

MySQL test does not work

Post by 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
Posts: 2832
Joined: Tue May 16, 2006 4:41 am
Contact:

Post by 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
Posts: 2
Joined: Tue Dec 17, 2013 3:51 pm

Post by mauricev »

SET PASSWORD FOR 'user'@'host' = OLD_PASSWORD('newpwd');
That worked. Thanks. 8)
KS-Soft Europe
Posts: 2832
Joined: Tue May 16, 2006 4:41 am
Contact:

Post by KS-Soft Europe »

You are welcome :)
Post Reply