To solve the 1862 (phpmyadmin)/1820 (mySQL) Error in mysql, 1862 phpmyadmin

To solve the 1862 (phpmyadmin)/1820 (mySQL) Error in mysql, 1862 phpmyadmin

Problems Found

I have been running well before, And suddenly mysql cannot work. An error is reported after the request command:ERROR 1820 (HY000): You must set password before executing this statementYou cannot log on using the phpMyAdmin management tool. The error is displayed: #1862 cannot log on to the MySQL server.

Troubleshooting

Log on to the mysql server and use the mysql Command for logon and operations.

1. log on to mysql:Mysql-uroot-proot

(Root is my account and password)

2. Check whether error 1820 is reported. Run the following statement:Mysql> select 1;

(An error is returned:ERROR 1820 (HY000): You must set password before executing this statement)

3. Set the new password:Mysql> set password = password ('root ');

(Because I do not need to change the password, reset the password to root again)

4. Try again to see if error 1820 is returned. Execute the statement:Mysql> select 1;

(The following data is returned, indicating that the problem has been resolved !)

Mysql> select 1; +-+ | 1 | +-+ | 1 | +-+ 1 row in set (0.00 sec)

Summary

The above is all about how to solve the Mysql 1862 (phpmyadmin)/1820 (mysql) error. I hope this article will help you in your study or work, if you have any questions, you can leave a message.