linux mysql ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

1. Error information

ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

2. Cause of error

This error means that the original password needs to be changed to execute a MySQL statement

3. Solutions

Log in to MySQL

mysql -u root -p

Change Password

mysql> SET PASSWORD = PASSWORD('123456'); 

4. Error report

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

It means that the password you set is not complicated enough. It’s better to use numbers + letters + special characters


Read More: