INFRA

centos - mysql5.1から5.6に移行

#CentOS#MySQL#OS・サーバ#データベース

5.1を削除して5.6をインストール

参考：CentOS6のMySQLを5.1から5.6にアップグレードする手順

$ mysql --version
mysql  Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1


$ rpm -qa | grep -i ^mysql
mysql-libs-5.1.73-5.el6_6.x86_64
mysql-server-5.1.73-5.el6_6.x86_64
mysql-5.1.73-5.el6_6.x86_64
mysql-devel-5.1.73-5.el6_6.x86_64


$ wget ftp://ftp.jaist.ac.jp/pub/mysql//Downloads/MySQL-5.6/MySQL-shared-compat-5.6.26-1.el6.x86_64.rpm
--2016-01-12 18:07:36--  ftp://ftp.jaist.ac.jp/pub/mysql//Downloads/MySQL-5.6/MySQL-shared-compat-5.6.26-1.el6.x86_64.rpm
           => `MySQL-shared-compat-5.6.26-1.el6.x86_64.rpm'
Resolving ftp.jaist.ac.jp... 150.65.7.130, 2001:df0:2ed:feed::feed
Connecting to ftp.jaist.ac.jp|150.65.7.130|:21... connected.
Logging in as anonymous ... Logged in!
==> SYST ... done.    ==> PWD ... done.
==> TYPE I ... done.  ==> CWD (1) /pub/mysql//Downloads/MySQL-5.6 ... done.
==> SIZE MySQL-shared-compat-5.6.26-1.el6.x86_64.rpm ... done.
==> PASV ... done.    ==> RETR MySQL-shared-compat-5.6.26-1.el6.x86_64.rpm ...
No such file `MySQL-shared-compat-5.6.26-1.el6.x86_64.rpm'.

No such fileと書いてある。

$ sudo rpm --nodeps -e mysql-5.1.73-5.el6_6.x86_64 mysql-server-5.1.73-5.el6_6.x86_64
warning: /var/log/mysqld.log saved as /var/log/mysqld.log.rpmsave


$ mysql --version
-bash: /usr/bin/mysql: No such file or directory


$ sudo yum install http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
....
mysql-devel-5.1.73-5.el6_6.x86_64 has missing requires of mysql = ('0', '5.1.73', '5.el6_6')
  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!


$ sudo yum install mysql mysql-devel mysql-server
...
Installed:
  mysql-community-client.x86_64 0:5.6.28-2.el6                     mysql-community-devel.x86_64 0:5.6.28-2.el6
  mysql-community-libs.x86_64 0:5.6.28-2.el6                       mysql-community-libs-compat.x86_64 0:5.6.28-2.el6
  mysql-community-server.x86_64 0:5.6.28-2.el6


Dependency Installed:
  mysql-community-common.x86_64 0:5.6.28-2.el6                                numactl.x86_64 0:2.0.9-2.el6


Dependency Updated:
  php.x86_64 0:5.3.3-46.el6_6                  php-cli.x86_64 0:5.3.3-46.el6_6            php-common.x86_64 0:5.3.3-46.el6_6
  php-devel.x86_64 0:5.3.3-46.el6_6            php-gd.x86_64 0:5.3.3-46.el6_6             php-mbstring.x86_64 0:5.3.3-46.el6_6
  php-mysql.x86_64 0:5.3.3-46.el6_6            php-pdo.x86_64 0:5.3.3-46.el6_6            php-xml.x86_64 0:5.3.3-46.el6_6
  postfix.x86_64 2:2.6.6-6.el6_7.1


Replaced:
  mysql-devel.x86_64 0:5.1.73-5.el6_6                                 mysql-libs.x86_64 0:5.1.73-5.el6_6


Complete!


$ mysql --version
mysql  Ver 14.14 Distrib 5.6.28, for Linux (x86_64) using  EditLine wrapper

mysqlが動かなくなった

参考：mysqlソケットエラー解決法

$ ls -al /var/lib/mysql/
なかったので作成してみる。
$ sudo -i
$ cd /var/lib/mysql
$ touch /var/lib/mysql/mysql.sock
$ chown mysql:mysql /var/lib/mysql
$ chown mysql:mysql /var/lib/mysql/mysql.sock
$ service mysqld start


MySQL Daemon failed to start.
Starting mysqld:                                           [FAILED]

起動できない。

/var/lib/mysql/mysql/の実行権限は全部