RedHat7.x环境下MySQL5.7的安装、配置和远程连接

安装、配置、远程连接MySQL

当下流行的系统版本 RedHat7.6 及数据库版本 MySQL5.7 的安装，实际操作过程，及中途遇到的一些不得不提及的坑。

一、RedHat7.6安装MySQL5.7

通过yum命令安装，在安装mysql之前需要安装mysql的下载源。需要从oracle的官方网站下载。

1、卸载系统预置的mariadb

[root@dbserver ~]# rpm -qa | grep -i mariadb
mariadb-libs-5.5.60-1.el7_5.x86_64
[root@dbserver ~]# rpm -qa | grep mariadb | xargs rpm -e --nodeps
[root@dbserver ~]# rpm -qa | grep -i mariadb

Tips：自mysql被sun收购以后，rh7已经不支持mysql（收费），内部集成了mariadb，安装mysql会与之冲突，因此需先卸载掉mariadb。

2、下载mysql5.7的yum源

[root@dbserver ~]# wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

Tips：一定要在http://repo.mysql.com/网站上面下载当前最新的yum源，否则可能会安装失败。

3、安装mysql的yum源

[root@dbserver ~]# rpm -ivh mysql-community-release-el7-5.noarch.rpm --force --nodeps
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql57-community-release-el7-11 ################################# [100%]

Tips：在使用rpm安装MySQL时可能出现警告，由于YUM安装了旧版本的GPG keys，在安装或升级软件包时会检查它的签名，后面跟上–force --nodeps参数即可规避掉告警。

4、安装完毕后，检查 /etc/yum.repos.d/ 目录下新增的YUM源文件：

[root@dbserver ~]# ll /etc/yum.repos.d/
total 8
-rw-r--r--. 1 root root 1838 Apr 27  2017 mysql-community.repo
-rw-r--r--. 1 root root 1885 Apr 27  2017 mysql-community-source.repo

5、查看可用的mysql发布版本安装文件：

[root@dbserver ~]# yum repolist all | grep mysql
mysql-cluster-7.5-community/x86_64 MySQL Cluster 7.5 Community      disabled
mysql-cluster-7.5-community-source MySQL Cluster 7.5 Community - So disabled
mysql-cluster-7.6-community/x86_64 MySQL Cluster 7.6 Community      disabled
mysql-cluster-7.6-community-source MySQL Cluster 7.6 Community - So disabled
mysql-connectors-community/x86_64  MySQL Connectors Community       enabled: 141
mysql-connectors-community-source  MySQL Connectors Community - Sou disabled
mysql-tools-community/x86_64       MySQL Tools Community            enabled: 105
mysql-tools-community-source       MySQL Tools Community - Source   disabled
mysql-tools-preview/x86_64         MySQL Tools Preview              disabled
mysql-tools-preview-source         MySQL Tools Preview - Source     disabled
mysql55-community/x86_64           MySQL 5.5 Community Server       disabled
mysql55-community-source           MySQL 5.5 Community Server - Sou disabled
mysql56-community/x86_64           MySQL 5.6 Community Server       disabled
mysql56-community-source           MySQL 5.6 Community Server - Sou disabled
mysql57-community/x86_64           MySQL 5.7 Community Server       enabled: 404
mysql57-community-source           MySQL 5.7 Community Server - Sou disabled
mysql80-community/x86_64           MySQL 8.0 Community Server       disabled
mysql80-community-source           MySQL 8.0 Community Server - Sou disabled

6、安装mysql数据库软件：

[root@dbserver ~]# yum install mysql-community-server
（...中间省略...）
Dependency Installed:
  mysql-community-client.x86_64 0:5.7.29-1.el7  mysql-community-common.x86_64 0:5.7.29-1.el7  mysql-community-libs.x86_64 0:5.7.29-1.el7
 
Complete!

7、安装完毕，查看是否安装成功：

[root@dbserver ~]# rpm -qa | grep mysql
mysql57-community-release-el7-11.noarch
mysql-community-client