mysql设置密码error_mysql root密码修改 error1819

mysql> alter user 'root'@'localhost' IDENTIFIED BY 'nancy';

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

mysql> SHOW VARIABLES LIKE 'validate_password%';

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

------修改密码策略密码长度

mysql> set global validate_password_policy=0;

Query OK, 0 rows affected (0.00 sec)

mysql> set global validate_password_length=4;

Query OK, 0 rows affected (0.00 sec)

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'nancy';

Query OK, 0 rows affected (0.01 sec)