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;
Perfect!!! You have successfully fix the error.