Zeoslib Portal

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

Hi,

please refer to the MySQL Reference Manual for further information.

Regards
Stevie

Hi,

I'm using Zeos to connect to MySQL, so do I have to pass some parameters with Zeos or do I have to do something else with Zeos to connect to the database?

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.

Quick solution without tampering with the server:
Rename libmysql.dll from your database distribution to libmysql41.dll. Works fine on Windows. I suppose a similar trick is possible with Linux.

Good Luck,

Mark

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