使用rpm包安装MySQL5.7.26

1、先安装一些基本工具

yum install -y vim wget ntp net-tools

2、卸载自带的mariadb

yum -y remove mariadb-libs

3、解压下载的MySQL包

cd /opt/

tar -xvf mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar

4、安装MySQL

yum install -y libaio

rpm -ivh mysql-community-common-5.7.26-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-5.7.26-1.el7.x86_64.rpm

rpm -ivh mysql-community-client-5.7.26-1.el7.x86_64.rpm

rpm -ivh mysql-community-server-5.7.26-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-compat-5.7.26-1.el7.x86_64.rpm

5、配置my.cnf

echo character-set-server=utf8 >> /etc/my.cnf

6、启动MySQL

systemctl enable mysqld && systemctl start mysqld && grep password /var/log/mysqld.log | sed 's/.*\(............\)$/\1/'

#修改密码策略

1、配置/etc/my.cnf文件，添加validate_password_policy配置，指定密码策略

# 选择0（LOW），1（MEDIUM），2（STRONG）其中一种，选择2需要提供密码字典文件

validate_password_policy=0

2、如果不需要密码策略，在my.cnf文件中，添加如下配置禁用即可：

validate_password = off

[root@localhost ~]# mysql -uroot –pqKTaFZnl

mysql> SET PASSWORD = PASSWORD('root');    #设置密码为root

mysql> exit

[root@localhost ~]# mysql -uroot -proot

7、允许远程登陆

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

mysql> flush privileges;

#开机启动设置

# systemctl enable mysqld

# systemctl daemon-reload