MySQL5.7的安装与配置

[toc]

1.MySQL官网下载

• MySQL官网下载MySQL Community Server 5.7.27
  

• Operating System: Red Hat Enterprise Linux/Oracle Linux
  

• OS Version: Red Hat Enterprise Linux 7 / Oracle Linux 7 (x86, 64-bit)
  

2.上传解压

[root@node5 ~]# tar -xvf mysql-5.7.29-1.el7.x86_64.rpm-bundle.tar

3.卸载mariadb
依赖

[root@node5 ~]# rpm -qa|grep mariadb
[root@node5 ~]# rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64

4.安装MySQL
依赖

[root@node5 ~]# yum install libaio perl

5.安装MySQL

[root@node5 ~]# rpm -ivh mysql-community-common-5.7.29-1.el7.x86_64.rpm

[root@node5 ~]# rpm -ivh mysql-community-libs-5.7.29-1.el7.x86_64.rpm

[root@node5 ~]# rpm -ivh mysql-community-client-5.7.29-1.el7.x86_64.rpm

[root@node5 ~]# rpm -ivh mysql-community-server-5.7.29-1.el7.x86_64.rpm

6.查看并配置MySQL状态

# 查看状态
[root@node5 ~]# systemctl status mysqld
# 启动
[root@node5 ~]# systemctl start mysqld
# 设置开机启动
[root@node5 ~]# systemctl enable mysqld

7.查看改初始密码

[root@node5 ~]# grep password /var/log/mysqld.log

8.修改初始密码并开启远程连接

[root@node5 ~]# mysql -u root -p 临时密码

# 登录成功后修改初始密码
mysql> set password = password("新密码")

# 开启远程连接
mysql> grant all privileges on *.* to 'root'@'%' identified by '远程连接密码' with grant option;

修改密码策略:

在配置文件/etc/my.cnf中，添加validate_password_policy配置：
 - 0: Low
 - 1: Medium
 - 2: Strong, 需要提供密码字典文件
 
 
    # 添加validate_password_policy配置
    validate_password_policy = 0
    # 关闭密码策略
    validate_password = off

9.修改配置文件

# 在/etc/my.cnf的[mysqld]下添加如下选项
character_set_server=utf8
max_allowed_packet = 500M

10.重启MySQL使修改生效

# 重启
[root@node5 /]# systemctl restart mysqld