Bug #3005 Cannot login when start mysqld using --old-passwords
Submitted: 28 Feb 2004 13:05 Modified: 6 Mar 2004 22:52
Reporter: li luo Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQLCC Severity:S2 (Serious)
Version:0.9.4b OS:Windows (Windows 2000 pro)
Assigned to: Bugs System CPU Architecture:Any

[28 Feb 2004 13:05] li luo 
Description:
when you:
1) start mysqld with argument --old-passwords
2) there is a user, say root, in db whose password is generate by the new
algorithm introduced in 4.1
3) login through MysqlCC using root and its password.

Login failed

How to repeat:
1) Install mysql 4.1.1a and MysqlCC 0.9.4b
2) Set password for some user, say root. The password should look like
"*006f97b114f597fdf08833b90ea7163eadc6fef351b4".
3) Restart mysqld with argument --old-passwords
4) Login as root through MysqlCC

Suggested fix:
mysql command line program does not have such problem.
Follow the step 1,2,3 in "How to repeat" and at step 4, login through mysql
commandline program, everything's O.K.
MysqlCC should have same function.
[6 Mar 2004 22:52] MySQL Verification Team 
Please use the libmysql.dll shipped together with 4.1.X
in the same directory of MySQLCC replacing the library
that MySQLCC copied in its directory. It is just incompatibility
of client protocol.
[7 Mar 2004 12:13] li luo 
hi, sorry I made a mistake. In the bug report I mentioned that 
my server version I used is 4.1.1a, in fact, however, it's 4.1.0a. 
4.1.0a did have the connection problem that I reported. I tried 
4.1.1a today and seems that the problem fixed in 4.1.1a.