SQLSTATE[HY000] [2000] mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication.

SQLSTATE[HY000] [2000] 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').

先確認一下是否真的是 16 個字的密碼長度

SELECT user, Length(Password) FROM mysql.user;

1	SELECT user, Length(Password) FROM mysql.user;

如果有修改權限試著把密碼改成新版格式

SET old_passwords = 0;
SET PASSWORD FOR 'User'@'Host'=PASSWORD('password');
FLUSH PRIVILEGES;

SET old_passwords = 0;

SET PASSWORD FOR 'User'@'Host'=PASSWORD('password');

FLUSH PRIVILEGES;

如果沒有操作權限，就按照錯誤訊息提示，直接 SET PASSWORD 重新設定密碼後測試看看

320 total views, 2 views today