linux安装mysql5.7(修改密码策略)

 

查看mysql 是否安装

linux安装mysql5.7(修改密码策略)

卸载mysql


rpm -ev MySQL-client-5.5.25a-1.rhel5 --nodeps

卸载完毕后,查看

linux安装mysql5.7(修改密码策略)

 

 

 

安装命令

wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm

如果没有安装wget的软件包先下载

Sudo yum install wget

 

 

安装下载

sudo rpm -ivh mysql57-community-release-el7-8.noarch.rpm

sudo yum install mysql-server

linux安装mysql5.7(修改密码策略)

 

 

calinux安装mysql5.7(修改密码策略)

 

删除原来安装过的mysql残留的数据(这一步非常重要,问题就出在这)
rm -rf /var/lib/mysql

重启mysql服务

systemctl restart mysqld

 

 

查看密码:

Cat /var/log/mysqld.log

 

linux安装mysql5.7(修改密码策略)

 

 

修改密码,报错

Your password does not satisfy the current policy requirements

linux安装mysql5.7(修改密码策略)

 

 

 

查看 mysql 初始的密码策略:

SHOW VARIABLES LIKE 'validate_password%';
 

linux安装mysql5.7(修改密码策略)

 

 

设置密码强度

set global validate_password_policy=LOW;

linux安装mysql5.7(修改密码策略)

设置密码长度

linux安装mysql5.7(修改密码策略)

set global validate_password_length=4;

 

修改密码

ALTER USER [email protected] IDENTIFIED BY ‘root’;

 

退出后重新登录

linux安装mysql5.7(修改密码策略)