What should I do if an 1862 error occurs in phpmyadmin?

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

Solution to phpmyadmin 1862 error:

Enter the mysql server and use the mysql command to log in and operate.

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

(root is my account and password)

2. Try to see whether to report an 1820 error , execute statement: mysql> select 1;

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

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

(Since I don’t need to change the password, I reset the password again to root)

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

(You will get the following return data, indicating that the problem has been solved! )

?
1234567    mysql> select 1;+—+| 1 |+—+| 1 |+—+1 row in set (0.00 sec)

Related tutorial recommendations: phpmyadmin

The above is the detailed content of What should I do if an 1862 error occurs in phpmyadmin?. For more information, please follow other related articles on the PHP Chinese website!