本周有客戶提交問題，說他在操作數(shù)據(jù)庫的時候會報錯，報錯如下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，這個問題是因為服務器上的數(shù)據(jù)庫版本與客戶的數(shù)據(jù)庫文件版本不一致導致的，需要使用命令重置下密碼就可以了。重置密碼的命令如下UPDATE mysql.user SET password=PASSWORD('11009380') WHERE User='a0106150047';
FLUSH PRIVILEGES;