003-安装mysql5.7

1、下载地址

https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.33-1.el7.x86_64.rpm-bundle.tar

2、卸载系统默认mariadb

rpm -qa | grep mariadb;
rpm -e mariadb-libs-5.5.60-1.el7_5.x86_64 --nodeps

3、上传并解压

mkdir /usr/local/mysql/
tar -vxf mysql-5.7.33-1.el7.x86_64.rpm-bundle.tar -C /usr/local/mysql/

5、安装

cd /usr/local/mysql/
rpm -ivh mysql-community-common-5.7.33-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.33-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.33-1.el7.x86_64.rpm
yum -y install perl.x86_64
rpm -ivh mysql-community-server-5.7.33-1.el7.x86_64.rpm

6、删除默认文件

rm -rf /var/lib/mysql/*

7、启动服务

service mysqld start
systemctl enable mysqld

8、查看默认密码

grep 'temporary password' /var/log/mysqld.log;

9、登录

mysql -u root -p aUuTak1Geg!k

10、重新设置密码

set password for 'root'@'localhost' = password('Root123@');
#修改密码验证强度
set global validate_password_policy=LOW;
set global validate_password_length=6;
set password for 'root'@'localhost' = password('123456');
#本地授权
grant all privileges on *.* to root@"%" identified by '123456' with grant option;
#远程授权
grant all privileges on *.* to root@localhost identified by '123456' with grant option;
#刷新权限
flush privileges;