mool

PHP5.2升到5.3之後遇到的php5-mysql錯誤

PHP Warning:  mysql_pconnect() 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 xxxxx.php on line 111

簡單說 , 就是告知mysqlnd已經用新的方式跟mysql連線, 而mysql server的PASSWORD是舊的store方式

解法1, 照訊息說的把MYSQL上的user做Set PASSWORD , 重新把密碼弄起來
解法2, php5-mysql  && make config 把 MYSQLND  Use MySQL Native Driver 拿掉