ERROR 1820 (HY000): You must reset your password using ALTER USER

In this tutorial, i will show you how to reset your MySQL Server password and fix this kind of MySQL errors :

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

Open terminal window or ssh then enter the following command to connect to your mysql server :

mysql -u root -p

then enter this MySQL command to reset your password :

SET PASSWORD = PASSWORD('your_new_password');

root@localhost [(none)]> SET PASSWORD = PASSWORD('your_new_password');
Query OK, 0 rows affected, 1 warning (0.01 sec)

Now enter this MySQL command to test if is working

SHOW DATABASES;

 root@localhost [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

IS DONE !!