Thử thêm cái coi lào
Feb
14
Config phpMyadmin voi MySQL
hrockvn , 14:00 , Networking , Nhận xét: (0) , Trích dẫn: (0) , Đọc: (1451) , Via Tự viết
Lớn | Vừa | Nhỏ
Lớn | Vừa | Nhỏ
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...
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...
How to configure your account to use PHP 4 on server using PHP5
Làm sao biết Users/Groups đã chỉnh sửa trên dữ liệu
