CentOS7 离线安装 MySql5.7

---

一、下载地址

https://download.csdn.net/download/java_road_far/11459574

---

二、删除自带的 MariaDB

rpm -qa | grep -i mariadb

rpm -e --nodeps mariadb-libs

---

三、解压安装

1. 将安装包剪切到 /usr/mysql/ 目录下

   [root@bigdata-12 mysql]# ll
   total 518440
   -rw-r--r-- 1 root root 530882560 Mar  2 17:15 mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar
   [root@bigdata-12 mysql]# tar -axvf mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar 
   mysql-community-embedded-devel-5.7.26-1.el7.x86_64.rpm
   mysql-community-libs-5.7.26-1.el7.x86_64.rpm
   mysql-community-embedded-5.7.26-1.el7.x86_64.rpm
   mysql-community-test-5.7.26-1.el7.x86_64.rpm
   mysql-community-embedded-compat-5.7.26-1.el7.x86_64.rpm
   mysql-community-common-5.7.26-1.el7.x86_64.rpm
   mysql-community-devel-5.7.26-1.el7.x86_64.rpm
   mysql-community-client-5.7.26-1.el7.x86_64.rpm
   mysql-community-server-5.7.26-1.el7.x86_64.rpm
   mysql-community-libs-compat-5.7.26-1.el7.x86_64.rpm
   [root@bigdata-12 mysql]# ll
   total 1036896
   -rw-r--r-- 1 root root  530882560 Mar  2 17:15 mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar
   -rw-r--r-- 1 7155 31415  25381952 Apr 15  2019 mysql-community-client-5.7.26-1.el7.x86_64.rpm
   -rw-r--r-- 1 7155 31415    280904 Apr 15  2019 mysql-community-common-5.7.26-1.el7.x86_64.rpm
   -rw-r--r-- 1 7155 31415   3838100 Apr 15  2019 mysql-community-devel-5.7.26-1.el7.x86_64.rpm
   -rw-r--r-- 1 7155 31415  47076368 Apr 15  2019 mysql-community-embedded-5.7.26-1.el7.x86_64.rpm
   -rw-r--r-- 1 7155 31415  24086952 Apr 15  2019 mysql-community-embedded-compat-5.7.26-1.el7.x86_64.rpm
   -rw-r--r-- 1 7155 31415 130023844 Apr 15  2019 mysql-community-embedded-devel-5.7.26-1.el7.x86_64.rpm
   -rw-r--r-- 1 7155 31415   2274268 Apr 15  2019 mysql-community-libs-5.7.26-1.el7.x86_64.rpm
   -rw-r--r-- 1 7155 31415   2118444 Apr 15  2019 mysql-community-libs-compat-5.7.26-1.el7.x86_64.rpm
   -rw-r--r-- 1 7155 31415 173541272 Apr 15  2019 mysql-community-server-5.7.26-1.el7.x86_64.rpm
   -rw-r--r-- 1 7155 31415 122249684 Apr 15  2019 mysql-community-test-5.7.26-1.el7.x86_64.rpm
   

2. 安装

   [root@bigdata-12 mysql]# rpm -ivh mysql-community-common-5.7.26-1.el7.x86_64.rpm 
   warning: mysql-community-common-5.7.26-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
   Preparing...                          ################################# [100%]
   Updating / installing...
      1:mysql-community-common-5.7.26-1.e################################# [100%]
   [root@bigdata-12 mysql]# rpm -ivh mysql-community-libs-5.7.26-1.el7.x86_64.rpm 
   warning: mysql-community-libs-5.7.26-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
   Preparing...                          ################################# [100%]
   Updating / installing...
      1:mysql-community-libs-5.7.26-1.el7################################# [100%]
   [root@bigdata-12 mysql]# rpm -ivh mysql-community-devel-5.7.26-1.el7.x86_64.rpm 
   warning: mysql-community-devel-5.7.26-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
   Preparing...                          ################################# [100%]
   Updating / installing...
      1:mysql-community-devel-5.7.26-1.el################################# [100%]
   [root@bigdata-12 mysql]# rpm -ivh mysql-community-libs-compat-5.7.26-1.el7.x86_64.rpm 
   warning: mysql-community-libs-compat-5.7.26-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
   Preparing...                          ################################# [100%]
   Updating / installing...
      1:mysql-community-libs-compat-5.7.2################################# [100%]
   [root@bigdata-12 mysql]# rpm -ivh mysql-community-client-5.7.26-1.el7.x86_64.rpm 
   warning: mysql-community-client-5.7.26-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
   Preparing...                          ################################# [100%]
   Updating / installing...
      1:mysql-community-client-5.7.26-1.e################################# [100%]
   [root@bigdata-12 mysql]# rpm -ivh mysql-community-server-5.7.26-1.el7.x86_64.rpm 
   warning: mysql-community-server-5.7.26-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
   Preparing...                          ################################# [100%]
   Updating / installing...
      1:mysql-community-server-5.7.26-1.e################################# [100%]
   [root@bigdata-12 mysql]# 
   
   

3. 启动MySql服务：

   查看MySql运行状态：service mysqld status

   启动MySql：systemctl start mysqld

   查看root随机密码：grep 'temporary password' /var/log/mysqld.log

4. 修改登录密码， MySQL的密码策略比较复杂，过于简单的密码会被拒绝

   mysql -u root -p
   
   mysql> Enter password: （输入刚才查询到的随机密码）
   
   mysql> SET PASSWORD FOR 'root'@'localhost'= "xxxxxxxx";
   
   mysql> exit
   

5. 设置root可以远程登录：

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

6. 开启防火墙mysql 3306端口的外部访问：

   firewall-cmd --zone=public --add-port=3306/tcp --permanent
   
   firewall-cmd --reload
   

7. 设置MySql忽略大小写：

   用root登录，打开并修改 vim /etc/my.cnf ；在[mysqld]节点下，加入一行： lower_case_table_names=1

   重启MySql服务：systemctl restart mysqld