I have installed mysql 8 on CentOS 9.
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?
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>';