• 環境：Cent OS 7
• MYSQL版本：??????
  [PS：資源，鏈接：https://pan.baidu.com/s/1QyUzWjgZw8vqKibi-_53dw 提取碼：df4c ]
  • MySQL-client-5.5.60-1.sles11.x86_64.rpm
  • MySQL-server-5.5.60-1.sles11.x86_64.rpm

1、查看 Cent OS 7 是否自帶 mariadb 及卸載步驟 # 1.1 查詢 [root@localhost ~]# rpm -qa | grep mariadb mariadb-libs-5.5.56-2.el7.x86_64 # 有返回值即代表安裝，具體版本號可不一樣# 1.2 卸載 mariadb [失敗命令] [root@localhost ~]# rpm -e mariadb-libs-5.5.56-2.el7.x86_64 #回顯如下則命令失敗： error: Failed dependencies:libmysqlclient.so.18()(64bit) is needed by (installed) postfix-2:2.10.1-6.el7.x86_64libmysqlclient.so.18(libmysqlclient_18)(64bit) is needed by (installed) postfix-2:2.10.1-6.el7.x86_64# 1.3 強制卸載 [成功命令] [root@localhost ~]# rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64# 1.4 校驗 mariadb 是否卸載成功 [無返回結果即代表成功] [root@localhost ~]# rpm -qa | grep mariadb

• 為什么要卸載mariadb？
• 原因：安裝MySQL的時候會和mariadb文件相沖突導致安裝不成功。
  
  

2、新建文件夾并復制MySQL

[root@localhost ~]# mkdir /opt/mysql# 復制MySQL-client-5.5.60-1.sles11.x86_64.rpmMySQL-server-5.5.60-1.sles11.x86_64.rpm 到 /opt/mysql 下

3、安裝MySQL服務端和客戶端

# 3.1 安裝 MySQL 服務端 [失敗命令] [root@localhost mysql]# rpm -ivh MySQL-server-5.5.60-1.sles11.x86_64.rpm #回顯如下則命令失敗： warning: MySQL-server-5.5.60-1.sles11.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY error: Failed dependencies:aaa_base is needed by MySQL-server-5.5.60-1.sles11.x86_64pwdutils is needed by MySQL-server-5.5.60-1.sles11.x86_64usr/bin/perl is needed by MySQL-server-5.5.60-1.sles11.x86_64# 3.2 強制安裝MySQL[root@localhost mysql]# rpm -ivh MySQL-server-5.5.60-1.sles11.x86_64.rpm --force --nodeps

執行結果見下圖：

[root@localhost mysql]# rpm -ivh MySQL-client-5.5.60-1.sles11.x86_64.rpm --force --nodeps

執行結果見下圖：



4、設置/修改MySQL密碼

# 4.1 設置MySQL密碼 [root@localhost mysql]# /usr/bin/mysql_secure_installation Enter current password for root (enter for none): [這里直接按 Enter] #輸入密碼后回顯如下則命令失敗，按 Ctrl+C 退出: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) # 原因：查看MySQL啟動狀態，可以看到MySQL服務沒有打開，所以修改密碼前必須先打開MySQL服務# 4.2 開啟MySQL服務 # 4.2.1 查看MySQL服務狀態 [root@localhost mysql]# service mysql status #回顯如下：ERROR! MySQL is not running# 4.2.2 開啟MySQL服務 [root@localhost mysql]# service mysql start #回顯如下：Starting MySQL.. SUCCESS!

見下圖：

# 4.3 再次修改密碼 # 4.3.1 [root@localhost mysql]# /usr/bin/mysql_secure_installation ... Enter current password for root (enter for none):[這里直接按 Enter] ... Set root password? [Y/n] [輸入 Y] New password: [輸入root用戶的登錄新密碼] Re-enter new password: [重復輸入新密碼] Password updated successfully! Reloading privilege tables..... Success!

見下圖：

5、測試MySQL安裝是否成功

[root@localhost mysql]# mysql -uroot -p Enter password:[輸入設置的root用戶密碼] #回顯如下，則安裝及設置密碼成功： Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 Server version: 5.5.60 MySQL Community Server (GPL)Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql>

總結

以上是生活随笔為你收集整理的二、Cent OS 7 下MySQL安装（安装版）的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。