MySQL 5 and Delphi 7

decho · Post by **decho** » 07.12.2005, 10:23

Hello !
I have a little problem with connection to MySQL server.
I am using ZEOS Lib and MySQL 5 with Delphi 7 Professional.
(zeosdbo-6.5.1-alpha_cvs_13-10-2005.zip)

When I try to login without password - everything work's fine
but
when I must enter the password to login then
the server display the error message:
"SQL Error: Client does not support authentication protocol requested by server; consider upgradin MySQL client"

I have the same problem with ODBC Connector.
(mysql-connector-odbc-noinstall-3.51.12-win32.zip)

Do You have a problem like this ?
What can I do ?

p.s. Sorry for my english

zippo · Post by **zippo** » 07.12.2005, 10:48

You're probably using an old libmysql.dll - check this. Since MySQL 4.1 the password coding has changed.

pol · Post by **pol** » 07.12.2005, 13:40

You can also start mysqld with --old-passwords or put old-passwords into my.ini in the [mysqld] section.

decho · Post by **decho** » 07.12.2005, 14:37

zippo wrote:You're probably using an old libmysql.dll - check this. Since MySQL 4.1 the password coding has changed.

I checked.
The lib used by me is the same lib witch is distributed with ZEOS-Lib package.

When I replace this (libmysql40.dll) lib with new LIB from MySQL 5 (libmySQL.dll) and change the filename of cors when the application crash.

pol wrote:You can also start mysqld with --old-passwords or put old-passwords into my.ini in the [mysqld] section.

Yes ! it works ! - (of cors after "flush-privileges")
Thank's You.

zippo · Post by **zippo** » 07.12.2005, 21:52

No problem - ask anytime!