Page 1 of 1
Error acessing mysql database with ZeosDB
Posted: 11.04.2007, 20:35
by Junior Thurler
I'm using ZeosDB on D6, and when I try to connect with a TZMySqlDatabase component to my database, I receive the following message:
"Client does not support authentication protocol requested by the server; consider upgrading MySql client".
I'm using MySql Server 5.0 and ZeosDB 5
What could be this problem ?
[]s
JR
Posted: 12.04.2007, 13:31
by mdaems
Problem is that you're using a protocol/dll which does not support the new authentication protocol used by mysql.
2 possible solutions (except for upgrading zeoslib, which has mysql5 support):
- Start the mysql server using 'old-passwords'. Read mysql docs about it. I don't think your dba will like it.
- Try to use a mysql 4.1 dll instead of the one you use now. This can give compatibility problems (dll interface may have changed). You just have to test it.
Mark
Posted: 12.04.2007, 20:36
by Junior Thurler
How can I upgrade my version of zeoslib since the name of components of the older version had changed ? There is a program to do that ?
JR
Posted: 13.04.2007, 09:35
by mdaems
Not officially, I'm sure about that. Some people have given a description of how they did it, however. You'll have to search a little on the forum for that. (unless somebody else can point you right there, of course)
Mark