AceBIT

Support Forum
It is currently Fri Aug 08, 2008 1:36 am

All times are UTC + 1 hour




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Unable to create database from Winsurvey 2005
PostPosted: Fri Mar 28, 2008 5:51 pm 
Offline
Rookie
Rookie

Joined: Fri Mar 28, 2008 5:43 pm
Posts: 2
Hello,

I've been trying to figure out what causes this error for days. The error message says:

"Could not create the database!
Client does not support authentication protocol requested by server; consider upgrading MySQL client"

I am using mySQL version 5.0.45. I have also tried 5.0.51a but it didn't make any difference.
I am able to connect with other client software (I have use SQLyog, among others, without any problem).

I have checked if a software firewall could block the 3306 port, but the firewall service isn't even running on the machine that hosts mySQL, which is not the same machine from which I run WinSurvey.

I have consulted the other forum threads but did not get any substantial clue from there.
At this point, I am lost. Can anyone help ?

Thanks,

Marc-Andre


Top
 Profile  
 
 Post subject: Re: Unable to create database from Winsurvey 2005
PostPosted: Mon Mar 31, 2008 9:51 am 
Offline
AceBIT
AceBIT

Joined: Tue Nov 28, 2006 5:11 pm
Posts: 747
Hello,

currently WinSurvey 2005 does not support the new style authentication. We would recommend you to create a separate user in your MySQL database with the possibility to use traditional passwords. Please see http://dev.mysql.com/doc/refman/5.0/en/old-client.html for more details.

Please also grant to that 'user' the possibility to log on to the database from external IP addresses (by default new users in MySQL 5 can connect only from localhost).

Best regards


Top
 Profile  
 
 Post subject: Re: Unable to create database from Winsurvey 2005
PostPosted: Mon Mar 31, 2008 2:46 pm 
Offline
Rookie
Rookie

Joined: Fri Mar 28, 2008 5:43 pm
Posts: 2
Thanks, the "old password" mode did the trick.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 0 guests


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 post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group