ITPub博客

首页 > 数据库 > MySQL > mysql root密码修改 error1819

mysql root密码修改 error1819

原创 MySQL 作者:nanlulululu 时间:2019-03-23 22:58:35 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
冲呀~姐妹们~

注册时间:2019-01-30

  • 博文量
    15
  • 访问量
    12018