MySQL 5.7 ERROR 1820 (HY000):

After the first login to MySQL 5.7, the MySQL database makes a lot of adjustments. Doing most of the operations will prompt this error:

ERROR 1820 (HY000): Must reset your password using ALTER USER statement before executing this statement.

This error is due to the rule that MySQL 5.7 requires updating the default password. Initial login mysql requires the root user password to be updated.

The following SQL can be used to adjust:

set Password=password (' password ');

After the operation is complete, you can do other things.

In addition, Mysql 5.7 requires a strong password by default. For password rules, see:

MySQL 5.7 ERROR 1820 (HY000):