View previous topic :: View next topic |
Author |
Message |
mauricev
Joined: 17 Dec 2013 Posts: 2
|
Posted: Tue Dec 17, 2013 4:06 pm Post subject: MySQL test does not work |
|
|
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: | 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). |
|
Back to top |
|
|
KS-Soft Europe
Joined: 16 May 2006 Posts: 2832
|
Posted: Tue Dec 17, 2013 4:33 pm Post subject: |
|
|
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. |
|
Back to top |
|
|
mauricev
Joined: 17 Dec 2013 Posts: 2
|
Posted: Tue Dec 17, 2013 4:36 pm Post subject: |
|
|
Quote: | SET PASSWORD FOR 'user'@'host' = OLD_PASSWORD('newpwd'); |
That worked. Thanks. |
|
Back to top |
|
|
KS-Soft Europe
Joined: 16 May 2006 Posts: 2832
|
Posted: Tue Dec 17, 2013 4:40 pm Post subject: |
|
|
You are welcome |
|
Back to top |
|
|
|