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)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/69908925/viewspace-2639190/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/69908925/viewspace-2639190/