Hello,
I have intalled Mysql 4.1.0 and MyODBC 3.51 under Windows 2000. I create a new database in Mysql and a user with all the privileges on it (using GRANT ALL privileges...). I create a User DSN in the windows Control Panel and when I test the connection (in the same DSN panel) I get the following message:
[MySQL][ODBC 3.51 Driver]Client does not support authentication protocol requested by server. Consider upgrading MySQL client
I get the same error if I try to connect using the Mysqlgui or from another application, but only if the mysql user has a password. If it does not have a password, it connects ok.
Last comment, this does not happen in all the machines, I have the same configuration installed in other machine (Windows2000, Mysql 4.1.0 and MyODBC 3.51) and I do not have this problem.
Does anybody knows what I am missing?
The authentication protocol and password hashing has changed in 4.1.
When you install MySQL 4.1, you should run the server with the --old-passwords option to tell it not to create new-style password hashes. After starting the server this way, you should also change the passwords of any accounts that you created while the server was running without --old-passwords. Otherwise, older clients will not be able to use those accounts.
You can recognize which accounts have new-style password hashes by looking in the user table of the mysql database. 16-byte values in the Password column use old hashing, longer values use new hashing.
http://www.mysql.com/doc/en/What-to-do-from-4.0.html
thanks, Laura.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]