Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in xxxx.php
原因: MySQL 4.1 以上版本使用了新的密碼驗證機制,
而 PHP 4.x 內建的 MySQL Library 是 3.23, 不支援新的密碼驗證機制.
解決方法:
mysql> SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpassword');
mysql> FLUSH PRIVILEGES;
ref. MySQL 5.0 Reference Manual :: A.2.3 Client does not support authentication protocol
MySQL 4.1.7 and PHP 4.3.x 搭配注意事項