KS-Soft. Network Management Solutions
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister    ProfileProfile    Log inLog in 

MySQL test does not work

 
Post new topic   Reply to topic    KS-Soft Forum Index -> Bug reports
View previous topic :: View next topic  
Author Message
mauricev



Joined: 17 Dec 2013
Posts: 2

PostPosted: Tue Dec 17, 2013 4:06 pm    Post subject: MySQL test does not work Reply with quote

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
View user's profile Send private message
KS-Soft Europe



Joined: 16 May 2006
Posts: 2832

PostPosted: Tue Dec 17, 2013 4:33 pm    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail Visit poster's website
mauricev



Joined: 17 Dec 2013
Posts: 2

PostPosted: Tue Dec 17, 2013 4:36 pm    Post subject: Reply with quote

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


That worked. Thanks.
Back to top
View user's profile Send private message
KS-Soft Europe



Joined: 16 May 2006
Posts: 2832

PostPosted: Tue Dec 17, 2013 4:40 pm    Post subject: Reply with quote

You are welcome
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    KS-Soft Forum Index -> Bug reports All times are GMT - 6 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

KS-Soft Forum Index