Bug #855 SQL Control Center cannot connect to 4.1.0 database

• Submitted: 16 Jul 2003 12:01
• Modified: 17 Jul 2003 5:04
• Reporter: Abraham Guyt
• Status: Not a Bug
• Category: MySQLCC
• Severity: S2 (Serious)
• Version: 0.9.2 beta
• OS: Windows (win xp)
• CPU Architecture: Any

[16 Jul 2003 12:01] Abraham Guyt

Description:
Using a freshly installed 4.1.0 mysql database, the 0.9.2 beta version of the MySql control center cannot make a connection, but states:

'Error 1249: Client does not support authentication protocol requested by server. Consider upgrading MySql client'.

I've investigated the problem a bit, and it seems that other client software has the same problem with version 4.1.0. PHP doesn't work either (same error message)

How to repeat:
simple repeat procedure described

Suggested fix:
fix 4.1.0 authentication protocol so that client software (SQL CC, PHP, older mysql clients) works again.

[17 Jul 2003 5:04] Indrek Siitan

Yes, 4.1.0 uses new authentication protocol and new more secure password encryption algorithm. 
The future versions of MySQLCC will be fixed to support 4.1.0 servers as well, but meanwhile the 
solution is to run 4.1.0 with old style passwords.

This is described on the following manual pages:
http://www.mysql.com/doc/en/Old_client.html
http://www.mysql.com/doc/en/Password_hashing.html