Hi,
I wanted to connect to an MySQL 5 Database
and got this error message
Test_Connection: EZSQLException
at $004E6312
SQL Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client.
How can I resolve that?
regards
musicones
Environment:
WinXP Prof
D7
ZeosLib 6.1.5
MySQL 5.0.12
No Authentication to MySQL 5
Moderators: gto, cipto_kh, EgonHugeist
Hello Musicones.
No additional parameter is needed at connection.
As Stevie remarks in his post, there's a note at mySQL that explains that password function used by mysql 4.1 and higher is different that the ones used for versions < 4.0.
In this case, Zeos 6.1.5 protocol used cannot be higher than 4.0. So, you are trying to enter to mysql 5.0 with the protocol for 4.0. The only way to do this is to update mysql settings in order to force the use of old-way password function. For this, update my.ini adding the following lines
#Use old password encryption method (needed for 4.1 and older clients).
old-passwords.
It would be nice if someone in the Zeos development team could confirm this point.
No additional parameter is needed at connection.
As Stevie remarks in his post, there's a note at mySQL that explains that password function used by mysql 4.1 and higher is different that the ones used for versions < 4.0.
In this case, Zeos 6.1.5 protocol used cannot be higher than 4.0. So, you are trying to enter to mysql 5.0 with the protocol for 4.0. The only way to do this is to update mysql settings in order to force the use of old-way password function. For this, update my.ini adding the following lines
#Use old password encryption method (needed for 4.1 and older clients).
old-passwords.
It would be nice if someone in the Zeos development team could confirm this point.
Another quick and less "dirty". Create or modify the users with the old_password function. More info on the page http://dev.mysql.com/doc/refman/5.0/en/old-client.html