phpmyadmin2054 error

phpmyadmin2054 error

This error occurs because MySQL 8 uses a new password verification plug-in by default: caching_sha2_password, while the previous PHP The mysqlnd included in the version cannot support this kind of verification. You need to reset the mysql password. Because the previous root password can no longer be used, you cannot use the traditional password modification method, but directly reset the password:

1. First modify the mysql configuration file my.cnf

Set any user to log in to obtain all permissions. Add a sentence in the [mysqld] section: skip-grant- tables and then restart mysql

2. Execute the sql to change the password:

UPDATE user SET Password = password ('new-password') WHERE User = 'root';
flush privileges;

3. Restart mysql again, it should be fine

For more PHP related knowledge, please visit PHP Chinese website!

The above is the detailed content of phpmyadmin2054 error. For more information, please follow other related articles on the PHP Chinese website!