Page 1 of 1

Protocol MySQL 5 Delphi 7

Posted: 07.12.2006, 14:09
by pttk
Hi,

I uninstall Zeos 6.1.5 and install 6.6.0 Beta in Delphi 7, I probe MySQL 5.0 connect, but need use mysql-4.1 protocol to connect, when try with other protocol:

mysql : Client does not support authentication protocol request by server....
mysql-4.1 : ok
mysql-5 : Client does not support authentication protocol request by server....
mysqld-4.1 : Access violation at address.......
mysqld-5 : Access violation at address.......

If use mysql-4.1 protocol in mysql 5.0 connections is ok?

Thank

Posted: 07.12.2006, 16:16
by mdaems
Hi,

I suppose you are still using an early 4.1 dll? The first 4.1 versions did not yet include the new authentication protocol, I think.

If you want to use mysql5 it's best to use a mysql5 dll. You can find it in your mysql distribution, but the version in the zeoslib 'lib' directory should work.
If you put it in your app directory or in the system path. (If you still need the 4.1 version think about the search sequence : appdir\libmysql5.dll, sysdir\libmysql5.dll, appdir\libmysql.dll, sysdir\libmysql.dll)

Is that sufficient?

Mark

Posted: 07.12.2006, 16:31
by pttk
Thank

I close and exit Delphi 7, and charge Delphi 7 again, open my project, change protocol for mysql5 and connect OK!!! to MySQL 5.0 engine.

I copy all libmy*.* to \winnt\system32

Thank again