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 statement
You 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.