Home Linux CentOS Mysql: You must reset your password using ALTER USER statement

[Fix] Mysql: You must reset your password using ALTER USER statement

I reset the mysql user password. It is asking for reset your password using ALTER USER statement before executing this statement.

I tried to check the databases available but I stuck with error ” ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement”. To fix this error I followed the following statement.

RECOMMENDED: How to Reset MySQL 5.7 Root User Password on CentOS 7

Run below command to reset user password.

mysql> SET PASSWORD = PASSWORD('Arunchandel@123');
mysql> FLUSH PRIVILEGES;
Reset user password using ALTER USER statementReset user password using ALTER USER statement




Perfect!!! You have successfully fix the error.

LEAVE A REPLY

Please enter your comment!
Please enter your name here