刚安装好mysql修改初始化密码会出现的错误提示
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
1、mysql5.7需要初始密码,先查看初始化密码:
cat /var/log/mysqld.log | grep password
2、执行 mysql -uroot -p'初始化密码'
,登陆mysql
mysql -uroot -p'k#&pB2j1t%f&'
如果不修改初始化密码,操作是会报错的:
mysql> use mysql;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement
3、直接设置简单的密码也会报错:
mysql> alter user 'root'@'localhost' identified by '123456';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
这种情况与validate_password_policy
的值有关
默认是1,即MEDIUM,所以刚开始设置的密码必须符合长度,且必须含有数字,小写或大写字母,特殊字符。
想设置简单的密码,则需要修改两个全局参数:
1)修改validate_password_policy参数的值:
mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)
2)validate_password_length(密码长度)参数默认为8,修改为1:
mysql> set global validate_password_length=1;
Query OK, 0 rows affected (0.00 sec)
4、完成以上操作再次执行修改密码的命令,就能成功了
mysql> alter user 'root'@'localhost' identified by '123456';
Query OK, 0 rows affected (0.00 sec)
再次执行use mysql;
命令就不会报错了
5、使用新密码登陆
至此,修改初始化密码就成功了!!!