Centos7修改mysql密码策略
mysql 安装步骤:
https://www.cnblogs.com/xiaopotian/p/8196464.html
安装完成后进入mysql没有密码:mysql -uroot -p ,提示输入密码时直接Enter
0、修改密码:
1)vi /etc/my.cnf
添加一段代码: skip-grant-tables
2)重启mysql:
免密登录mysql
use mysql;
update user set authentication_string=password('123456') where user='root';
或者
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
3)去掉my.cnf文件中追加的skip**内容
重启mysql
systemctl restart mysqld.service
1、报错处理
ERROR 1146 (42S02): Table 'performance_schema.session_variables' doesn't exist
1)输入命令:
mysql_upgrade -u root -p --force
2)重启mysql
systemctl restart mysqld.service
2、修改安全策略
1)查看当前策略:
SHOW VARIABLES LIKE 'validate_password%';
2)修改策略项
set global validate_password_policy=0;
set global validate_password_mixed_case_count=0;
set global validate_password_special_char_count=0;
set global validate_password_length=6;
3、授权
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
FLUSH PRIVILEGES;