I am using MySQL 4.1 alpha for windows for new development. Is MyODBC 3.51.06 supposed to work for MySQL 4.1 alpha? I get message [MySQL][ODBC 3.51 Driver]Client does not support authentication protocol requested by server. Consider upgrading MySQL client. Any clue about when MyODBC 3.52 will be released?
The MyOLEDB version I am using is 3.0
many thanks, rajendra
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
-- 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]