ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
今天在MySql5.7操作时报错:You must SET PASSWORD before executing this statement,解决方法:
ERROR 1820 (HY000): You must SET PASSWORD before executing this statementmysql> create database cma;
ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
mysql> SET PASSWORD = PASSWORD('123456');
Query OK, 0 rows affected (0.03 sec) 遇到1820的错误,需要重设密码,使用命令:
SET PASSWORD = PASSWORD('123456');