Shulou(Shulou.com)06/01 Report--

This article will explain in detail the solution to the 1862 error in phpmyadmin. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

The solution to the phpmyadmin 1862 error: first log in to mysql and execute the statement [mysql > select 1;]; then set the new password with the code [mysql > set password=password ('root')]; and finally check.

Solutions to phpmyadmin 1862 errors:

Log in and operate with the mysql instruction in the server of mysql.

1. Log in to mysql:mysql-uroot-proot

(root is my account number and password)

2. Try whether or not to report a 1820 error, execute the statement: mysql > select 1

(you will get an error: ERROR 1820 (HY000): You must SET PASSWORD before executing this statement)

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

(since I don't need to change my password, I reset it to root again.)

4. Try again whether or not to report a 1820 error, execute the statement: mysql > select 1

(you will get the following returned data, indicating that the problem has been solved!)

? 1234567 mysql > select 1 row in set + | 1 | +-+ | 1 | +-+ 1 row in set (sec) this article ends here. I hope the above content can be helpful to you so that you can learn more knowledge. If you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.