Error 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement
centos
mysql
Software and digital electronics / IT
2024-02-09 05:19
Environment Setup
I have installed mysql 8 on CentOS 9.
Problem
Upon entering may commands, MySQL issues this error to me:
Error 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement
How should I get around this error?
add comment
Answered by ernest1
2024-07-09 05:38
You probably have just installed a mysql server and you are working on a fresh server. You will need to reset the password as advised by the mysql error.
alter user 'root'@'localhost' identified by '<new password>';
add comment