Thử thêm cái coi lào
Feb 14

Config phpMyadmin voi MySQL

Welcome to the hell that is php/mysql ....your version of php doesn't have support for mysql 4.1.x's new password hashing algorithm. If you can connect directly to your mysql database, execute the following:

mysql> use mysql;

mysql> SET PASSWORD FOR 'username'@'hostname' = OLD_PASSWORD('password');

mysql> FLUSH PRIVILEGES;


where username is your mysql user that you're trying to connect as, hostname is the host (probably localhost in your case) and the last 'password' is the password you wish your user to use.

This will revert the password back to the older algorithm and should allow php to connect again. To force new accounts to be made with the old style passwords, you can edit /etc/my.cnf and add "old-passwords" as an option under the [mysqld] section and restart mysql...
Tags: , ,