CentOS7(最新では無い)へMySQL(最新では無い)をインストールした覚書


#### バージョンの確認

とある事情により、MySQL5.6 以上環境が必要になったので、MacOS/X El Captan 10.11.1 上の VMware Fusionで動作しているCentOS7 へインストールしました。

まずはバージョンの確認。

	$ cat /etc/redhat-release
	CentOS Linux release 7.1.1503 (Core)

最近はMariaDB化しているはずなので確認してみると、

	$ yum list installed | grep maria
	mariadb-libs.x86_64                    1:5.5.44-1.el7_1                @updates
	
やっぱり居たｗ ので、一応アンインストール。

	$ sudo yum -y remove mariadb-libs
	Loaded plugins: fastestmirror, langpacks
	Resolving Dependencies
	--> Running transaction check
	---> Package mariadb-libs.x86_64 1:5.5.44-1.el7_1 will be erased
	--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-6.el7.x86_64
	--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-6.el7.x86_64
	--> Running transaction check
	---> Package postfix.x86_64 2:2.10.1-6.el7 will be erased
	--> Finished Dependency Resolution
	base/7/x86_64                                            | 3.6 kB     00:00     
	extras/7/x86_64                                          | 3.4 kB     00:00     
	extras/7/x86_64/primary_db                               |  99 kB     00:01     
	updates/7/x86_64                                         | 3.4 kB     00:00     
	
	Dependencies Resolved
	
	================================================================================
	 Package            Arch         Version                  Repository       Size
	================================================================================
	Removing:
	 mariadb-libs       x86_64       1:5.5.44-1.el7_1         @updates        4.4 M
	Removing for dependencies:
	 postfix            x86_64       2:2.10.1-6.el7           @anaconda        12 M
	
	Transaction Summary
	================================================================================
	Remove  1 Package (+1 Dependent package)
	
	Installed size: 17 M
	Downloading packages:
	Running transaction check
	Running transaction test
	Transaction test succeeded
	Running transaction
	  Erasing    : 2:postfix-2.10.1-6.el7.x86_64                                1/2 
	  Erasing    : 1:mariadb-libs-5.5.44-1.el7_1.x86_64                         2/2 
	  Verifying  : 1:mariadb-libs-5.5.44-1.el7_1.x86_64                         1/2 
	  Verifying  : 2:postfix-2.10.1-6.el7.x86_64                                2/2 
	
	Removed:
	  mariadb-libs.x86_64 1:5.5.44-1.el7_1                                          
	
	Dependency Removed:
	  postfix.x86_64 2:2.10.1-6.el7                                                 
	
	Complete!

細かくバージョン指定できるとはいえ、今回は新しければ良い！(つーか、5.5以前はダメよ)という感じだし、サクッとyumでインストール。

	$ sudo yum -y install http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
	Loaded plugins: fastestmirror, langpacks
	mysql-community-release-el7-5.noarch.rpm                 | 6.0 kB     00:01     
	Examining /var/tmp/yum-root-40KiJj/mysql-community-release-el7-5.noarch.rpm: mysql-community-release-el7-5.noarch
	Marking /var/tmp/yum-root-40KiJj/mysql-community-release-el7-5.noarch.rpm to be installed
	Resolving Dependencies
	--> Running transaction check
	---> Package mysql-community-release.noarch 0:el7-5 will be installed
	--> Finished Dependency Resolution
	
	Dependencies Resolved
	
	================================================================================
	 Package               Arch   Version
                                    Repository                             Size
	================================================================================
	Installing:
	 mysql-community-release
	                       noarch el7-5 /mysql-community-release-el7-5.noarch 4.3 k
	
	Transaction Summary
	================================================================================
	Install  1 Package
	
	Total size: 4.3 k
	Installed size: 4.3 k
	Downloading packages:
	Running transaction check
	Running transaction test
	Transaction test succeeded
	Running transaction
	  Installing : mysql-community-release-el7-5.noarch                         1/1 
	  Verifying  : mysql-community-release-el7-5.noarch                         1/1 
	
	Installed:
	  mysql-community-release.noarch 0:el7-5                                        
	
	Complete!

リポジトリファイルがインストールできたら、本体をインストール。

	$ sudo yum -y install mysql
	Loaded plugins: fastestmirror, langpacks
	mysql-connectors-community                               | 2.5 kB     00:00     
	mysql-tools-community                                    | 2.5 kB     00:00     
	mysql56-community                                        | 2.5 kB     00:00     
	(1/3): mysql-tools-community/x86_64/primary_db             |  22 kB   00:01     
	(2/3): mysql-connectors-community/x86_64/primary_db        | 8.6 kB   00:01     
	(3/3): mysql56-community/x86_64/primary_db                 | 109 kB   00:02     
	Loading mirror speeds from cached hostfile
	 * base: mirror.fairway.ne.jp
	 * extras: centos.usonyx.net
	 * updates: centos.usonyx.net
	Resolving Dependencies
	--> Running transaction check
	---> Package mysql-community-client.x86_64 0:5.6.27-2.el7 will be installed
	--> Processing Dependency: mysql-community-libs(x86-64) = 5.6.27-2.el7 for package: mysql-community-client-5.6.27-2.el7.x86_64
	--> Running transaction check
	---> Package mysql-community-libs.x86_64 0:5.6.27-2.el7 will be installed
	--> Processing Dependency: mysql-community-common(x86-64) = 5.6.27-2.el7 for package: mysql-community-libs-5.6.27-2.el7.x86_64
	--> Running transaction check
	---> Package mysql-community-common.x86_64 0:5.6.27-2.el7 will be installed
	--> Finished Dependency Resolution
	
	Dependencies Resolved
	
	================================================================================
	 Package                   Arch      Version         Repository            Size
	================================================================================
	Installing:
	 mysql-community-client    x86_64    5.6.27-2.el7    mysql56-community     19 M
	Installing for dependencies:
	 mysql-community-common    x86_64    5.6.27-2.el7    mysql56-community    256 k
	 mysql-community-libs      x86_64    5.6.27-2.el7    mysql56-community    2.0 M
	
	Transaction Summary
	================================================================================
	Install  1 Package (+2 Dependent packages)
	
	Total download size: 21 M
	Installed size: 99 M
	Downloading packages:
	warning: /var/cache/yum/x86_64/7/mysql56-community/packages/mysql-community-common-5.6.27-2.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
	Public key for mysql-community-common-5.6.27-2.el7.x86_64.rpm is not installed
	(1/3): mysql-community-common-5.6.27-2.el7.x86_64.rpm      | 256 kB   00:01     
	(2/3): mysql-community-client-5.6.27-2.el7.x86_64.rpm      |  19 MB   00:06     
	(3/3): mysql-community-libs-5.6.27-2.el7.x86_64.rpm        | 2.0 MB   00:07     
	--------------------------------------------------------------------------------
	Total                                              2.3 MB/s |  21 MB  00:09     
	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>"
	 Fingerprint: a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5
	 Package    : mysql-community-release-el7-5.noarch (@/mysql-community-release-el7-5.noarch)
	 From       : file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
	Running transaction check
	Running transaction test
	Transaction test succeeded
	Running transaction
	  Installing : mysql-community-common-5.6.27-2.el7.x86_64                   1/3 
	  Installing : mysql-community-libs-5.6.27-2.el7.x86_64                     2/3 
	  Installing : mysql-community-client-5.6.27-2.el7.x86_64                   3/3 
	  Verifying  : mysql-community-client-5.6.27-2.el7.x86_64                   1/3 
	  Verifying  : mysql-community-common-5.6.27-2.el7.x86_64                   2/3 
	  Verifying  : mysql-community-libs-5.6.27-2.el7.x86_64                     3/3 
	
	Installed:
	  mysql-community-client.x86_64 0:5.6.27-2.el7                                  
	
	Dependency Installed:
	  mysql-community-common.x86_64 0:5.6.27-2.el7                                  
	  mysql-community-libs.x86_64 0:5.6.27-2.el7                                    
	
	Complete!

続けて、残りのパッケージもインストールします(ログログ省略)。

	$ sudo yum -y install mysql-devel
	$ sudo yum -y install mysql-server
	$ sudo yum -y install mysql-utilities

	$ which mysql
	/usr/bin/mysql
	$ sudo service mysqld start
	Redirecting to /bin/systemctl start  mysqld.service

さて、今はserviceではなくsystemctlでやる方法に変わっているので、起動登録を行います。

	$ sudo systemctl list-unit-files | grep mysql
	mysql.service                               enabled 
	mysqld.service                              enabled

さてさて、最近は便利になりましたね―！なセットアップです。

	$ sudo mysql_secure_installation

ログは省略します。

起動終了などなどのコマンドは以下の通りです。

	$ sudo systemctl start mysqld.service
	$ sudo systemctl stop mysqld.service
	$ sudo systemctl restart mysqld.service

※追加
外部からのアクセスですが、my.cnfやiptables、mysqlでのgrantなどはググればいっぱい出てきます。
今回一番ハマったのは、firewall-cmdでした。

以下の通りに行えば、外部からのアクセスを通すようになります。

	$ which firewall-cmd
	/usr/bin/firewall-cmd
	コマンドを確認
	
	$ sudo firewall-cmd --get-service
	RH-Satellite-6 amanda-client bacula bacula-client dhcp dhcpv6 dhcpv6-client dns ftp high-availability 	http https imaps ipp ipp-client ipsec kerberos kpasswd ldap ldaps libvirt libvirt-tls mdns mountd ms-wbt 	mysql nfs ntp openvpn pmcd pmproxy pmwebapi pmwebapis pop3s postgresql proxy-dhcp radius rpc-bind samba 	samba-client smtp ssh telnet tftp tftp-client transmission-client vnc-server wbem-https
	今許可している設定はどうなってる？
	
	$ sudo firewall-cmd --permanent --add-service=mysql
	success
	mysqlの通常設定も許可してね
	
	$ sudo firewall-cmd --reload
	success
	再起動