mysql5.7安装和修改密码

• 上传mysql的rpm包解压

[mysql-5.7.31-1.el7.x86_64.rpm-bundle.tar]

SQL tar -xf mysql*****.tar

• 检查机器上是否安装有mysql，有的话删除

SQL #检查是否mysql 、 mariadb rpm -qa |grep mysql rpm -qa |grep mariadb #删除 rpm -e --nodeps mysql*****

• 安装mysql5.7的依赖

SQL yum -y install libaio  yum -y install net-tools  yum -y install perl

• 依照顺序安装

SQL rpm -ivh mysql-community-common-5.7.31-1.el7.x86_64.rpm rpm -ivh mysql-community-libs-5.7.31-1.el7.x86_64.rpm rpm -ivh mysql-community-client-5.7.31-1.el7.x86_64.rpm rpm -ivh mysql-community-server-5.7.31-1.el7.x86_64.rpm

• 启动mysql

SQL systemctl start mysqld systemctl status mysqld

 

• 找到初始密码登陆mysql，密码中的;和（需要转译

SQL mysql -uroot -pEsp\;a%f8\(/7%

• 修改密码

报错如下

SQL alter user 'root'@'localhost' identified by 'root'; flush privileges;

修改下边参数，再执行修改密码就好了

SQL set global validate_password_policy=LOW; set global validate_password_length=4;