前回の記事でyumの勉強をしたので、ついでにMySQLの最新版を入れてみたいと思います
Step1. 自分のサーバのOSバージョンを確認しとく
MySQLでは、インストールするyumリポジトリがサーバのOSバージョン毎に用意されてるので、予め確認しておきましょう。
# cat /etc/redhat-release
CentOS release 6.5 (Final)
私のはcentos 6.5でした。
step2. MySQLの公式からyumリポジトリを探しに行きます
mysqlの公式に、各OS毎のyumリポジトリがありますので、自分のOSに合うもののダウンロードページへ行きます。
Downloadボタンをクリック
Loginとか気にせずURLをコピー
step3. 公式リポジトリを追加する
# yum install http://dev.mysql.com/get/mysql57-community-release-el6-8.noarch.rpm
Loaded plugins: fastestmirror, security
Loading mirror speeds from cached hostfile
* base: ftp.iij.ad.jp
* extras: ftp.iij.ad.jp
* updates: ftp.iij.ad.jp
Setting up Install Process
mysql57-community-release-el6-8.noarch.rpm | 8.9 kB 00:00
Examining /var/tmp/yum-root-sWSouw/mysql57-community-release-el6-8.noarch.rpm: mysql57-community-release-el6-8.noarch
Marking /var/tmp/yum-root-sWSouw/mysql57-community-release-el6-8.noarch.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package mysql57-community-release.noarch 0:el6-8 will be installed
--> Processing Conflict: mysql57-community-release-el6-8.noarch conflicts mysql-community-release
No package matched to upgrade: mysql57-community-release
--> Finished Dependency Resolution
Error: mysql57-community-release conflicts with mysql-community-release-el7-5.noarch
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
おや、なんかすでにあるMySQLと競合したっぽいので、インストール済みのMySQLを確認してみましょう。
# yum list installed | grep mysql
mysql-community-common.x86_64
5.6.14-3.el6 @mysql-community
mysql-community-devel.x86_64
5.6.14-3.el6 @mysql-community
mysql-community-embedded.x86_64
5.6.14-3.el6 @mysql-community
mysql-community-embedded-devel.x86_64
5.6.14-3.el6 @mysql-community
mysql-community-libs.x86_64
5.6.14-3.el6 @mysql-community
mysql-community-libs-compat.x86_64
5.6.14-3.el6 @mysql-community
mysql-community-release.noarch
el7-5 @/mysql-community-release-el7-5.noarch
php-mysqlnd.x86_64 5.5.16-1.el6.remi.2
どうやらすでに色々入ってました。消しちゃいましょう
# yum remove mysql*
Loaded plugins: fastestmirror, security
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-common.x86_64 0:5.6.14-3.el6 will be erased
---> Package mysql-community-devel.x86_64 0:5.6.14-3.el6 will be erased
---> Package mysql-community-embedded.x86_64 0:5.6.14-3.el6 will be erased
---> Package mysql-community-embedded-devel.x86_64 0:5.6.14-3.el6 will be erased
---> Package mysql-community-libs.x86_64 0:5.6.14-3.el6 will be erased
---> Package mysql-community-libs-compat.x86_64 0:5.6.14-3.el6 will be erased
---> Package mysql-community-release.noarch 0:el7-5 will be erased
--> Finished Dependency Resolution
Dependencies Resolved
=========================================================================================================================================================================
Package Arch Version Repository Size
=========================================================================================================================================================================
Removing:
mysql-community-common x86_64 5.6.14-3.el6 @mysql-community 2.1 M
mysql-community-devel x86_64 5.6.14-3.el6 @mysql-community 19 M
mysql-community-embedded x86_64 5.6.14-3.el6 @mysql-community 78 M
mysql-community-embedded-devel x86_64 5.6.14-3.el6 @mysql-community 356 M
mysql-community-libs x86_64 5.6.14-3.el6 @mysql-community 8.4 M
mysql-community-libs-compat x86_64 5.6.14-3.el6 @mysql-community 5.3 M
mysql-community-release noarch el7-5 @/mysql-community-release-el7-5.noarch 4.3 k
Transaction Summary
=========================================================================================================================================================================
Remove 7 Package(s)
Installed size: 469 M
Is this ok [y/N]: y
Downloading Packages:
... 中略 ...
Complete!
さて、もう公式リポジトリを追加してみましょう。
# yum install http://dev.mysql.com/get/mysql57-community-release-el6-8.noarch.rpm
Loaded plugins: fastestmirror, security
Loading mirror speeds from cached hostfile
* base: ftp.iij.ad.jp
* extras: ftp.iij.ad.jp
* updates: ftp.iij.ad.jp
Setting up Install Process
mysql57-community-release-el6-8.noarch.rpm | 8.9 kB 00:00
Examining /var/tmp/yum-root-sWSouw/mysql57-community-release-el6-8.noarch.rpm: mysql57-community-release-el6-8.noarch
Marking /var/tmp/yum-root-sWSouw/mysql57-community-release-el6-8.noarch.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package mysql57-community-release.noarch 0:el6-8 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
=========================================================================================================================================================================
Package Arch Version Repository Size
=========================================================================================================================================================================
Installing:
mysql57-community-release noarch el6-8 /mysql57-community-release-el6-8.noarch 8.2 k
Transaction Summary
=========================================================================================================================================================================
Install 1 Package(s)
Total size: 8.2 k
Installed size: 8.2 k
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : mysql57-community-release-el6-8.noarch 1/1
Verifying : mysql57-community-release-el6-8.noarch 1/1
Installed:
mysql57-community-release.noarch 0:el6-8
Complete!
今度は追加出来ました。
追加が完了すると、mysql-community-serverという名前のパッケージがインストール出来るようになりますので、インストールします。
# yum -y install mysql-community-server
Loaded plugins: fastestmirror, security
Loading mirror speeds from cached hostfile
* base: ftp.iij.ad.jp
* extras: ftp.iij.ad.jp
* updates: ftp.iij.ad.jp
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:5.7.13-1.el6 will be installed
--> Processing Dependency: mysql-community-common(x86-64) >= 5.7.9 for package: mysql-community-server-5.7.13-1.el6.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 5.7.9 for package: mysql-community-server-5.7.13-1.el6.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:5.7.13-1.el6 will be installed
--> Processing Dependency: mysql-community-libs(x86-64) >= 5.7.9 for package: mysql-community-client-5.7.13-1.el6.x86_64
---> Package mysql-community-common.x86_64 0:5.7.13-1.el6 will be installed
--> Running transaction check
---> Package mysql-community-libs.x86_64 0:5.7.13-1.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
=========================================================================================================================================================================
Package Arch Version Repository Size
=========================================================================================================================================================================
Installing:
mysql-community-server x86_64 5.7.13-1.el6 mysql57-community 143 M
Installing for dependencies:
mysql-community-client x86_64 5.7.13-1.el6 mysql57-community 22 M
mysql-community-common x86_64 5.7.13-1.el6 mysql57-community 327 k
mysql-community-libs x86_64 5.7.13-1.el6 mysql57-community 2.1 M
Transaction Summary
=========================================================================================================================================================================
Install 4 Package(s)
Total download size: 167 M
Installed size: 840 M
Downloading Packages:
(1/4): mysql-community-client-5.7.13-1.el6.x86_64.rpm | 22 MB 00:02
(2/4): mysql-community-common-5.7.13-1.el6.x86_64.rpm | 327 kB 00:00
(3/4): mysql-community-libs-5.7.13-1.el6.x86_64.rpm | 2.1 MB 00:00
(4/4): mysql-community-server-5.7.13-1.el6.x86_64.rpm | 143 MB 00:14
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 9.9 MB/s | 167 MB 00:16
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : mysql-community-common-5.7.13-1.el6.x86_64 1/4
Installing : mysql-community-libs-5.7.13-1.el6.x86_64 2/4
Installing : mysql-community-client-5.7.13-1.el6.x86_64 3/4
Installing : mysql-community-server-5.7.13-1.el6.x86_64 4/4
Verifying : mysql-community-client-5.7.13-1.el6.x86_64 1/4
Verifying : mysql-community-common-5.7.13-1.el6.x86_64 2/4
Verifying : mysql-community-libs-5.7.13-1.el6.x86_64 3/4
Verifying : mysql-community-server-5.7.13-1.el6.x86_64 4/4
Installed:
mysql-community-server.x86_64 0:5.7.13-1.el6
Dependency Installed:
mysql-community-client.x86_64 0:5.7.13-1.el6 mysql-community-common.x86_64 0:5.7.13-1.el6 mysql-community-libs.x86_64 0:5.7.13-1.el6
Complete!
step4. インストールできたことを確認する
# mysqld --version
mysqld Ver 5.7.13 for Linux on x86_64 (MySQL Community Server (GPL))
最新版のインストールに成功しました！
お疲れ様です。
こんにちわ！色々噂のMySQL5.7！！ｗ