Problem with connecting

[QPRocky]

Hi.

I'm having problem to get connected to database.
I have MySQL 5.0 server and Zeos 6.6.3.

I added ZConnection to form, added to properties username and password
and selected protocol mysql-5.

When I try to change connected property, i get following message:
"Client does not support authentication protocol requested by server; Consider upgrading MySQL client"

What should I actually upgrade or what I need to do?

Thanks in advance.


edit.

Never mind. I found solution with google.
I writed this to mysql:
SET PASSWORD FOR user@localhost = OLD_PASSWORD('password');

[mdaems]

Not quite sure about your solution. If I'm not wrong : this message means you are using an old libmysql.dll version to connect to the database. Or you might be running your mysql server in a special mode to use the old authentication protocol.
Maybe you could test the client and server versions by evaluating the values of ZConnection1.ClientVersionStr and ZConnection1.ServerVersionStr.
These should both indicate mysql 5 is used.

Mark

[zippo]

Have you upgraded mysql form 3.x or 4.0 to 5.x? The message means you are using old password coding mechanisms - a newer libmysql.dll should resolve the problem.