mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication

文章介绍了关于mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication方法,有需要了解的同学可参考一下.

1. Warning: mysql_connect() [function.mysql-connect]: Premature end of data (mysqlnd_wireprotocol.c:554) in path/to/the/file/where/connection/script/is/written/ 
2.  
3. Warning: mysql_connect() [function.mysql-connect]: OK packet 1 bytes shorter than expected in path/to/the/file/where/connection/script/is/written/ 
4. --Vevb.com 
5. Warning: mysql_connect() [function.mysql-connect]: mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file in path/to/the/file/where/connection/script/is/written/ 

1.Change MySQL to NOT to use old_passwords 

It seems that even MySQL 5.x versions still default to the old password hashes. You need to change this in “my.cnf” (e.g. /etc/my.cnf): remove or comment out the line that says:

1. old_passwords = 1 
2.  // 
3. old_passwords = 1为16位 
4. //所以这里要先 
5. / 
6. /SET old_passwords = 0; 
7. //这样使新密码的长度也变成41位 
8. Restart MySQL. If you don’t, MySQL will keep using the old password format, which will mean that you cannot upgrade the passwords using the builtin PASSWORD() hashing function. You can test this by running: 

具体原因我还不是很清楚,跟old密码长度有关？先记录下来,日后研究,解决方法如下:

1. SET old_passwords = 0; 
2. UPDATE mysql.user SET PASSWORD = PASSWORD( 'www.Vevb.com' ) WHERE User = 'chajian8' LIMIT 1 ; 
3. SELECT LENGTH( PASSWORD ) FROM mysql.user WHERE User = 'chajian8'; 
4. FLUSH PRIVILEGES ; 

附,PHP连接MySQL测试代码:

1. <?php 
2. $con = mysql_connect("192.168.3.240:3306","chajian8",www.Vevb.com); 
3. if (!$con)  
4. { 
5.  die('Could not connect: ' . mysql_error()); 
6. } 
7. ?>