Re: Passwords and ODBC - what am I missing

[Randy Chrismon]

Ken Brown wrote:

Just installed 4.1.1 on windows 2000 with current odbc layer

Connects fine with root and no password

But if I set a password on root or create a user with a password odbc fails
with


"Client does not support authentication protocol requested by the server -
consider upgrading MYSql Client"


So what have I done wrong?



Ken

 

Ken:

You will have to look up the exact switch in the MySQL manual but the 
problem is that the OBDC driver is sending the "old" style password hash 
to MySQL 4.1.1 which is expecting the new -- longer -- password hash. 
You can easily find the switch by searching the MySQL documentation at 
their site.

Randy

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]