1. 檢查系統(tǒng)自帶的Mysql，并卸載自帶的版本

[root@iZ2366ycl7sZ config]# yum list installed |grep mysql
mysql.x86_64 5.1.73-5.el6_6 @base
mysql-libs.x86_64 5.1.73-5.el6_6 @base
php56w-mysql.x86_64 5.6.40-1.w6 @webtatic </pre>

2. 卸載系統(tǒng)自帶的mysql及其依賴

[root@iZ2366ycl7sZ config]# yum -y remove mysql-libs.x86_64
Loaded plugins: security
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package mysql-libs.x86_64 0:5.1.73-5.el6_6 will be erased
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: php56w-mysql-5.6.40-1.w6.x86_64
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: 2:postfix-2.6.6-6.el6_5.x86_64
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: mysql-5.1.73-5.el6_6.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: php56w-mysql-5.6.40-1.w6.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: 2:postfix-2.6.6-6.el6_5.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: mysql-5.1.73-5.el6_6.x86_64
--> Processing Dependency: libmysqlclient_r.so.16()(64bit) for package: php56w-mysql-5.6.40-1.w6.x86_64
--> Processing Dependency: libmysqlclient_r.so.16()(64bit) for package: mysql-5.1.73-5.el6_6.x86_64
--> Processing Dependency: libmysqlclient_r.so.16(libmysqlclient_16)(64bit) for package: php56w-mysql-5.6.40-1.w6.x86_64
--> Processing Dependency: libmysqlclient_r.so.16(libmysqlclient_16)(64bit) for package: mysql-5.1.73-5.el6_6.x86_64
--> Processing Dependency: mysql-libs for package: 2:postfix-2.6.6-6.el6_5.x86_64
--> Processing Dependency: mysql-libs = 5.1.73-5.el6_6 for package: mysql-5.1.73-5.el6_6.x86_64
--> Running transaction check
---> Package mysql.x86_64 0:5.1.73-5.el6_6 will be erased
---> Package php56w-mysql.x86_64 0:5.6.40-1.w6 will be erased
---> Package postfix.x86_64 2:2.6.6-6.el6_5 will be erased
--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================================
Package Arch Version Repository Size
========================================================================================================================================
Removing:
mysql-libs x86_64 5.1.73-5.el6_6 @base 4.0 M
Removing for dependencies:
mysql x86_64 5.1.73-5.el6_6 @base 2.4 M
php56w-mysql x86_64 5.6.40-1.w6 @webtatic 457 k
postfix x86_64 2:2.6.6-6.el6_5 @updates 9.7 M

Transaction Summary

Remove 4 Package(s)

Installed size: 17 M
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Erasing : php56w-mysql-5.6.40-1.w6.x86_64 1/4
Erasing : 2:postfix-2.6.6-6.el6_5.x86_64 2/4
Erasing : mysql-5.1.73-5.el6_6.x86_64 3/4
Erasing : mysql-libs-5.1.73-5.el6_6.x86_64 4/4
Verifying : mysql-libs-5.1.73-5.el6_6.x86_64 1/4
Verifying : php56w-mysql-5.6.40-1.w6.x86_64 2/4
Verifying : mysql-5.1.73-5.el6_6.x86_64 3/4
Verifying : 2:postfix-2.6.6-6.el6_5.x86_64 4/4

Removed:
mysql-libs.x86_64 0:5.1.73-5.el6_6

Dependency Removed:
mysql.x86_64 0:5.1.73-5.el6_6 php56w-mysql.x86_64 0:5.6.40-1.w6 postfix.x86_64 2:2.6.6-6.el6_5

Complete!</pre>

給****CentOS****添加****rpm****源，并且選擇較新的源

1）下載rpm包

<pre style="box-sizing: border-box; font-family: Monaco, Menlo, Consolas, "Courier New", monospace; font-size: 12px; white-space: pre-wrap; display: block; padding: 9.5px; margin: 0px 0px 10px; line-height: 1.38462; color: rgb(51, 51, 51); word-break: break-all; overflow-wrap: break-word; background-color: rgb(245, 245, 245); border: 1px solid rgb(204, 204, 204); border-radius: 4px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;">[root@iZ2366ycl7sZ software]# wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm --no-check-certificate
--2019-03-29 14:45:46-- http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
Resolving dev.mysql.com... 137.254.60.11
Connecting to dev.mysql.com|137.254.60.11|:80... connected.
HTTP request sent, awaiting response... 301 Moved Permanently
Location: https://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm [following]
--2019-03-29 14:45:46-- https://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
Connecting to dev.mysql.com|137.254.60.11|:443... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://repo.mysql.com//mysql-community-release-el6-5.noarch.rpm [following]
--2019-03-29 14:45:48-- https://repo.mysql.com//mysql-community-release-el6-5.noarch.rpm
Resolving repo.mysql.com... 104.127.195.16
Connecting to repo.mysql.com|104.127.195.16|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 5824 (5.7K) [application/x-redhat-package-manager]
Saving to: “mysql-community-release-el6-5.noarch.rpm”

100%[==============================================================================================>] 5,824 --.-K/s in 0s

2019-03-29 14:45:48 (506 MB/s) - “mysql-community-release-el6-5.noarch.rpm” saved [5824/5824]</pre>

2）安裝本地mysql源

Dependencies Resolved

Transaction Summary

Install 1 Package(s)

Total size: 4.3 k
Installed size: 4.3 k
Is this ok [y/N]: y
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : mysql-community-release-el6-5.noarch 1/1
Verifying : mysql-community-release-el6-5.noarch 1/1

Installed:
mysql-community-release.noarch 0:el6-5

Complete!</pre>

3）驗證是否安裝成功

<pre style="box-sizing: border-box; font-family: Monaco, Menlo, Consolas, "Courier New", monospace; font-size: 12px; white-space: pre-wrap; display: block; padding: 9.5px; margin: 0px 0px 10px; line-height: 1.38462; color: rgb(51, 51, 51); word-break: break-all; overflow-wrap: break-word; background-color: rgb(245, 245, 245); border: 1px solid rgb(204, 204, 204); border-radius: 4px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;">[root@iZ2366ycl7sZ software]# yum repolist all | grep mysql
mysql-connectors-community MySQL Connectors Community enabled: 83
mysql-connectors-community-source MySQL Connectors Community - S disabled
mysql-tools-community MySQL Tools Community enabled: 74
mysql-tools-community-source MySQL Tools Community - Source disabled
mysql55-community MySQL 5.5 Community Server disabled
mysql55-community-source MySQL 5.5 Community Server - S disabled
mysql56-community MySQL 5.6 Community Server enabled: 493
mysql56-community-source MySQL 5.6 Community Server - S disabled
mysql57-community-dmr MySQL 5.7 Community Server Dev disabled
mysql57-community-dmr-source MySQL 5.7 Community Server Dev disabled</pre>

4）修改默認版本為5.7

注：如下是截取的老徐之前文章 -》原文 <u style="box-sizing: border-box;">http://istester.com/huanjing/134.html</u>

如上，默認是5.6版本可用咪笑，如果想安裝5.7怎么操作徙鱼？

有如下兩個方法：

方法一：

執(zhí)行：

yum-config-manager --disable mysql56-community

yum-config-manager --enable mysql57-community-dmr

如上操作，是把5.6禁用惭聂，把5.7啟用

此法窗声，會有異常情況：

如果執(zhí)行命令出現(xiàn)如下錯誤：

-bash: yum-config-manager: command not found

可用執(zhí)行如下命令解決，然后繼續(xù)上面的操作命令：

yum -y install yum-utils

注意：如上操作可能有一部分同學(xué)的會出現(xiàn)一些問題辜纲；好處是操作簡單笨觅，兩個命令搞定～

如果有問題，底部給老徐留言～

方法二：

直接編輯配置文件耕腾，簡單见剩、直接，基本不會出現(xiàn)錯誤～

vi /etc/yum.repos.d/mysql-community.repo

把5.6的enabled=0

把5.7的enabled=1

然后保存就ok

Enable to use MySQL 5.5

[mysql55-community]

name=MySQL 5.5 Community Server

baseurl=http://repo.mysql.com/yum/mysql-5.5-community/el/6/$basearch/

enabled=0

gpgcheck=1

gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

Enable to use MySQL 5.6

[mysql56-community]

name=MySQL 5.6 Community Server

baseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/6/$basearch/

enabled=0

gpgcheck=1

gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

Note: MySQL 5.7 is currently in development. For use at your own risk.

Please read with sub pages: https://dev.mysql.com/doc/relnotes/mysql/5.7/en/

[mysql57-community-dmr]

name=MySQL 5.7 Community Server Development Milestone Release

baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/6/$basearch/

enabled=1

gpgcheck=1

gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

如上扫俺，顏色標記處苍苞。

此時，再執(zhí)行：

yum repolist all | grep mysql

就可以看到狼纬，5.7是啟用的

[root@localhost webserver]# yum repolist all | grep mysql

mysql-connectors-community MySQL Connectors Community 啟用: 21

mysql-connectors-community-source MySQL Connectors Community - Sourc 禁用

mysql-tools-community MySQL Tools Community 啟用: 38

mysql-tools-community-source MySQL Tools Community - Source 禁用

mysql55-community MySQL 5.5 Community Server 禁用

mysql55-community-source MySQL 5.5 Community Server - Sourc 禁用

mysql56-community MySQL 5.6 Community Server 禁用

mysql56-community-source MySQL 5.6 Community Server - Sourc 禁用

mysql57-community-dmr MySQL 5.7 Community Server Develop 啟用: 130

mysql57-community-dmr-source MySQL 5.7 Community Server Develop 禁用

如上羹呵。

OK，至此疗琉，基礎(chǔ)準備工作完成冈欢。

4. 安裝mysql

執(zhí)行如下命令：

yum install mysql-community-server

<pre style="box-sizing: border-box; font-family: Monaco, Menlo, Consolas, "Courier New", monospace; font-size: 12px; white-space: pre-wrap; display: block; padding: 9.5px; margin: 0px 0px 10px; line-height: 1.38462; color: rgb(51, 51, 51); word-break: break-all; overflow-wrap: break-word; background-color: rgb(245, 245, 245); border: 1px solid rgb(204, 204, 204); border-radius: 4px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;">**[root@iZ2366ycl7sZ software]# yum install mysql-community-server
Loaded plugins: security
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:5.7.25-1.el6 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 5.7.25-1.el6 for package: mysql-community-server-5.7.25-1.el6.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 5.7.9 for package: mysql-community-server-5.7.25-1.el6.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:5.7.25-1.el6 will be installed
--> Processing Dependency: mysql-community-libs(x86-64) >= 5.7.9 for package: mysql-community-client-5.7.25-1.el6.x86_64
---> Package mysql-community-common.x86_64 0:5.7.25-1.el6 will be installed
--> Running transaction check
---> Package mysql-community-libs.x86_64 0:5.7.25-1.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================================
Package Arch Version Repository Size
========================================================================================================================================
Installing:
mysql-community-server x86_64 5.7.25-1.el6 mysql57-community-dmr 153 M
Installing for dependencies:
mysql-community-client x86_64 5.7.25-1.el6 mysql57-community-dmr 23 M
mysql-community-common x86_64 5.7.25-1.el6 mysql57-community-dmr 332 k
mysql-community-libs x86_64 5.7.25-1.el6 mysql57-community-dmr 2.1 M

Transaction Summary

Install 4 Package(s)

Total download size: 178 M
Installed size: 887 M
Is this ok [y/N]: y
Downloading Packages:
(1/4): mysql-community-client-5.7.25-1.el6.x86_64.rpm | 23 MB 00:01
(2/4): mysql-community-common-5.7.25-1.el6.x86_64.rpm | 332 kB 00:00
(3/4): mysql-community-libs-5.7.25-1.el6.x86_64.rpm | 2.1 MB 00:00
(4/4): mysql-community-server-5.7.25-1.el6.x86_64.rpm | 153 MB 00:04

Total 32 MB/s | 178 MB 00:05
warning: rpmts_HdrFromFdno: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Retrieving key from file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Importing GPG key 0x5072E1F5:
Userid : MySQL Release Engineering mysql-build@oss.oracle.com
Package: mysql-community-release-el6-5.noarch (@/mysql-community-release-el6-5.noarch)
From : file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Is this ok [y/N]: y
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : mysql-community-common-5.7.25-1.el6.x86_64 1/4
Installing : mysql-community-libs-5.7.25-1.el6.x86_64 2/4
Installing : mysql-community-client-5.7.25-1.el6.x86_64 3/4
Installing : mysql-community-server-5.7.25-1.el6.x86_64 4/4
Verifying : mysql-community-libs-5.7.25-1.el6.x86_64 1/4
Verifying : mysql-community-common-5.7.25-1.el6.x86_64 2/4
Verifying : mysql-community-client-5.7.25-1.el6.x86_64 3/4
Verifying : mysql-community-server-5.7.25-1.el6.x86_64 4/4

Installed:
mysql-community-server.x86_64 0:5.7.25-1.el6

Dependency Installed:
mysql-community-client.x86_64 0:5.7.25-1.el6 mysql-community-common.x86_64 0:5.7.25-1.el6 mysql-community-libs.x86_64 0:5.7.25-1.el6

Complete!**</pre>

5. 啟動mysql

6. 查看mysql服務(wù)狀態(tài)

7. 查看mysql 初始密碼

mysql5.7之后初始密碼不再默認為空

其中，最后的xo%LBtyoo2MV 就是密碼

8. 命令行登錄mysql 盈简，并修改密碼

登錄之后第一步必須先修改密碼凑耻，

否則其他操作都執(zhí)行不了。

修改密碼的方法：

alter user root@localhost identified by 'passwd';

'passwd' 里柠贤，填寫你的新密碼香浩。

新修改的密碼中必須包含大小寫字母數(shù)字及符號

</pre>

End 。

完整的mysql相關(guān)操作臼勉，見之前的文章 http://istester.com/huanjing/134.html

補充邻吭，

搭建博客的文章文章 -》 http://istester.com/bushu/254.html

Centos 下 mysql 安裝過程

Centos 下 mysql 安裝過程

Transaction Summary

Transaction Summary

Enable to use MySQL 5.5

Enable to use MySQL 5.6

Note: MySQL 5.7 is currently in development. For use at your own risk.

Please read with sub pages: https://dev.mysql.com/doc/relnotes/mysql/5.7/en/

Transaction Summary

'passwd' 里柠贤，填寫你的新密碼香浩。

Centos 下 mysql 安裝過程

Transaction Summary

Transaction Summary

Enable to use MySQL 5.5

Enable to use MySQL 5.6

Note: MySQL 5.7 is currently in development. For use at your own risk.

Please read with sub pages: https://dev.mysql.com/doc/relnotes/mysql/5.7/en/

Transaction Summary

'passwd' 里柠贤，填寫你的新密碼 香浩。

'passwd' 里柠贤，填寫你的新密碼香浩。