| 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 |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in
