PHP5.3連接MySQL出現 mysqlnd cannot connect to MySQL 4.1+ using old authentication錯誤
1、編輯my.cnf注釋掉一下行:
old_passwords = 1
2、重啟MySQL
service mysqld restart
/etc/inint.d/mysqld restart
3、檢查是否有16位的密碼
SELECT user, Length(`Password`) FROM `mysql`.`user`;
4、如果有,把對應的用戶名密碼用以下SQL更新
UPDATE mysql.user SET Password = PASSWORD('password') WHERE user = 'username';
5、更新后要刷新
FLUSH PRIVILEGES;