いなばのタイカレーを食べてみた

みんながおすすめのイエローのヤツ。

やばい。

チョー美味かった。

茶碗1膳のご飯とあわせて食べたら、すごく、いい感じだったと報告。

いなばのタイカレーを買っちゃった

昼ご飯を食べながら、たまたま「花子とアン」の総集編を観ましたよ。
ちょっと、おもしろいじゃないですか。
毎日観る気にはならないけれど、ダイジェストで90分はアリですね。

あと、「いなばのタイカレー♪」。
ジャニーズJr.の子の歌が耳について離れな〜い。
というわけで、買ったよ。2個ずつ3種類。
レビューは後日。

いま人形町にはいいタイ料理屋が集まっていて、月に2〜3回はタイカレーを食べてる。
昔はタイ料理、ぜんぜんダメだったんだけどなー。
もっと早く食べれるようになっておきたかったよ。
タイ料理バージンだった俺に、いきなりトムヤンクンを強要したアイツが悪い。


夏は残り45回

激しい雨が続いた梅雨が今週明けて、暑苦しいヤツがやってきた。
肌にまとわりつく蒸し暑さは本当にうんざりなのだけど。

朝、駅までの7分間、関空から欧州に向かう彼氏と話しながら歩いた。
家を出て、街路樹の陰を伝いながら移動するけれど、すぐに汗ばんでくる。
僕は、暑い、暑いと連呼しながら歩く。

梅雨明けの空を見上げて、ふと、夏はあと45回なんだなあと呟いた。

十歳の子供にとって、45回目の夏は高校生か、大学生の子供を育てている頃だろう。
二十歳の夏を迎える人は、45回目の夏は、定年退職後初の夏かもしれない。
今年三十歳で夏を見上げている人は、45回目の夏は、連れ合いを亡くした静かな季節かもしれないね。

そして僕にとっての45回目の夏は、たぶん、この世で迎えることはないんだろう。
どんな楽観的に考えても、最後の2回は、ガラス窓の向こうから、手を振っている夏をベッドの上から眺めているような気がする。

そんなことをつらつら考えていたら、今年の夏が特別に感じた。
みんな、身体が自由なうちに、夏と遊びに行ってこい。

で、MroongaはDBエンジンとして奉職しているのかというと。

調べてみよう。

mysql> show engines;
+--------------------+---------+----------------------------------------------------------------+
| Engine             | Support | Comment                                                        +--------------------+---------+----------------------------------------------------------------
  MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables      |
  MRG_MYISAM         | YES     | Collection of identical MyISAM tables                          |
  CSV                | YES     | CSV storage engine                                             |
  BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears) |
  MyISAM             | YES     | MyISAM storage engine                                          |
  InnoDB             | DEFAULT | Supports transactions, row-level locking, and foreign keys     |
  mroonga            | YES     | CJK-ready fulltext search, column store                        |
  FEDERATED          | NO      | Federated MySQL storage engine                                 |
  PERFORMANCE_SCHEMA | YES     | Performance Schema                                             |
  ARCHIVE            | YES     | Archive storage engine                                         |
+--------------------+---------+----------------------------------------------------------------
 10 rows in set (0.00 sec)

ちゃんといるね。

CentOS6.5でGroongaを利用するため、MySQL5.5インストールからやり直し。

Mroonga、Rroongaをインストールするために、MySQL5シリーズをインストールしようとしたんだけど、最新版だと弾かれてしまう。結局、Mroongaのインストール手順に書いてあったやり方にしたがって、MySQL5からインストールするのが一番の近道だった。ちょっと泣きたい気分。orz

手順を残しておく。
最初の作業。

# yum install centos-release-SCL
Loaded plugins: fastestmirror, refresh-packagekit, security
Determining fastest mirrors
 * base: www.ftp.ne.jp
 * extras: www.ftp.ne.jp
 * updates: www.ftp.ne.jp
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package centos-release-SCL.x86_64 10:6-5.el6.centos will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package                 Arch        Version                  Repository   Size
================================================================================
Installing:
 centos-release-SCL      x86_64      10:6-5.el6.centos        extras      3.9 k

Transaction Summary
================================================================================
Install       1 Package(s)

Total download size: 3.9 k
Installed size: 453 
Is this ok [y/N]: y
Downloading Packages:
centos-release-SCL-6-5.el6.centos.x86_64.rpm             | 3.9 kB     00:00    
警告: rpmts_HdrFromFdno: ヘッダ V3 RSA/SHA1 Signature, key ID c105b9de: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6
Importing GPG key 0xC105B9DE:
 Userid : CentOS-6 Key (CentOS 6 Official Signing Key)
 Package: centos-release-6-5.el6.centos.11.1.x86_64 (@anaconda-CentOS-201311272149.x86_64/6.5)
 From   : /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6
Is this ok [y/N]: y
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : 10:centos-release-SCL-6-5.el6.centos.x86_64                  1/1
  Verifying  : 10:centos-release-SCL-6-5.el6.centos.x86_64                  1/1

Installed:
  centos-release-SCL.x86_64 10:6-5.el6.centos                                  

Complete!

次の作業。

# rpm -ivh http://packages.groonga.org/centos/groonga-release-1.1.0-1.noarch.rpm
http://packages.groonga.org/centos/groonga-release-1.1.0-1.noarch.rpm を取得中
警告: /var/tmp/rpm-tmp.2F4WFq: ヘッダ V4 DSA/SHA1 Signature, key ID 45499429: NOKEY
準備中...                ########################################### [100%]
   1:groonga-release        ########################################### [100%]
[root@centos6 ruby_on_rails]# yum makecache
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
 * base: www.ftp.ne.jp
 * extras: www.ftp.ne.jp
 * updates: www.ftp.ne.jp
base                                                     | 3.7 kB     00:00    
base/filelists_db                                        | 5.9 MB     00:06    
base/other_db                                            | 2.8 MB     00:02    
extras                                                   | 3.4 kB     00:00    
extras/filelists_db                                      |  11 kB     00:00    
extras/prestodelta                                       |  907 B     00:00    
extras/other_db                                          | 5.8 kB     00:00    
groonga                                                  | 2.5 kB     00:00    
groonga/filelists_db                                     | 172 kB     00:00    
groonga/primary_db                                       | 139 kB     00:00    
groonga/other_db                                         | 160 kB     00:00    
scl                                                      | 2.9 kB     00:00    
scl/filelists_db                                         | 1.2 MB     00:02    
scl/other_db                                             | 711 kB     00:01    
updates                                                  | 3.4 kB     00:00    
updates/filelists_db                                     | 2.3 MB     00:02    
updates/prestodelta                                      | 365 kB     00:00    
Metadata Cache Created

では、MySQL5をインストールする。

# yum install -y mysql55-mysql-server
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
 * base: www.ftp.ne.jp
 * extras: www.ftp.ne.jp
 * updates: www.ftp.ne.jp
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql55-mysql-server.x86_64 0:5.5.37-1.2.el6.centos.alt will be installed
--> Processing Dependency: mysql55-mysql-libs(x86-64) = 5.5.37-1.2.el6.centos.alt for package: mysql55-mysql-server-5.5.37-1.2.el6.centos.alt.x86_64
--> Processing Dependency: mysql55-mysql(x86-64) = 5.5.37-1.2.el6.centos.alt for package: mysql55-mysql-server-5.5.37-1.2.el6.centos.alt.x86_64
--> Processing Dependency: perl-DBD-MySQL for package: mysql55-mysql-server-5.5.37-1.2.el6.centos.alt.x86_64
--> Processing Dependency: mysql55-runtime for package: mysql55-mysql-server-5.5.37-1.2.el6.centos.alt.x86_64
--> Running transaction check
---> Package mysql55-mysql.x86_64 0:5.5.37-1.2.el6.centos.alt will be installed
---> Package mysql55-mysql-libs.x86_64 0:5.5.37-1.2.el6.centos.alt will be installed
---> Package mysql55-runtime.x86_64 0:1-14.el6.centos.alt will be installed
--> Processing Dependency: policycoreutils-python for package: mysql55-runtime-1-14.el6.centos.alt.x86_64
---> Package perl-DBD-MySQL.x86_64 0:4.013-3.el6 will be installed
--> Running transaction check
---> Package policycoreutils-python.x86_64 0:2.0.83-19.39.el6 will be installed
--> Processing Dependency: libsemanage-python >= 2.0.43-4 for package: policycoreutils-python-2.0.83-19.39.el6.x86_64
--> Processing Dependency: audit-libs-python >= 1.4.2-1 for package: policycoreutils-python-2.0.83-19.39.el6.x86_64
--> Processing Dependency: setools-libs-python for package: policycoreutils-python-2.0.83-19.39.el6.x86_64
--> Running transaction check
---> Package audit-libs-python.x86_64 0:2.2-4.el6_5 will be installed
--> Processing Dependency: audit-libs = 2.2-4.el6_5 for package: audit-libs-python-2.2-4.el6_5.x86_64
---> Package libsemanage-python.x86_64 0:2.0.43-4.2.el6 will be installed
---> Package setools-libs-python.x86_64 0:3.3.7-4.el6 will be installed
--> Processing Dependency: setools-libs = 3.3.7-4.el6 for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libsefs.so.4(VERS_4.0)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libseaudit.so.4(VERS_4.2)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libseaudit.so.4(VERS_4.1)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libqpol.so.1(VERS_1.4)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libqpol.so.1(VERS_1.3)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libqpol.so.1(VERS_1.2)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libpoldiff.so.1(VERS_1.3)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libpoldiff.so.1(VERS_1.2)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libapol.so.4(VERS_4.1)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libapol.so.4(VERS_4.0)(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libsefs.so.4()(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libseaudit.so.4()(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libqpol.so.1()(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libpoldiff.so.1()(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Processing Dependency: libapol.so.4()(64bit) for package: setools-libs-python-3.3.7-4.el6.x86_64
--> Running transaction check
---> Package audit-libs.x86_64 0:2.2-2.el6 will be updated
--> Processing Dependency: audit-libs = 2.2-2.el6 for package: audit-2.2-2.el6.x86_64
---> Package audit-libs.x86_64 0:2.2-4.el6_5 will be an update
---> Package setools-libs.x86_64 0:3.3.7-4.el6 will be installed
--> Running transaction check
---> Package audit.x86_64 0:2.2-2.el6 will be updated
---> Package audit.x86_64 0:2.2-4.el6_5 will be an update
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package                  Arch     Version                      Repository
                                                                           Size
================================================================================
Installing:
 mysql55-mysql-server     x86_64   5.5.37-1.2.el6.centos.alt    scl        10 M
Installing for dependencies:
 audit-libs-python        x86_64   2.2-4.el6_5                  updates    59 k
 libsemanage-python       x86_64   2.0.43-4.2.el6               base       81 k
 mysql55-mysql            x86_64   5.5.37-1.2.el6.centos.alt    scl       5.7 M
 mysql55-mysql-libs       x86_64   5.5.37-1.2.el6.centos.alt    scl       217 k
 mysql55-runtime          x86_64   1-14.el6.centos.alt          scl       1.0 M
 perl-DBD-MySQL           x86_64   4.013-3.el6                  base      134 k
 policycoreutils-python   x86_64   2.0.83-19.39.el6             base      343 k
 setools-libs             x86_64   3.3.7-4.el6                  base      400 k
 setools-libs-python      x86_64   3.3.7-4.el6                  base      222 k
Updating for dependencies:
 audit                    x86_64   2.2-4.el6_5                  updates   225 k
 audit-libs               x86_64   2.2-4.el6_5                  updates    60 k

Transaction Summary
================================================================================
Install      10 Package(s)
Upgrade       2 Package(s)

Total download size: 19 M
Downloading Packages:
(1/12): audit-2.2-4.el6_5.x86_64.rpm                     | 225 kB     00:00    
(2/12): audit-libs-2.2-4.el6_5.x86_64.rpm                |  60 kB     00:00    
(3/12): audit-libs-python-2.2-4.el6_5.x86_64.rpm         |  59 kB     00:00    
(4/12): libsemanage-python-2.0.43-4.2.el6.x86_64.rpm     |  81 kB     00:00    
(5/12): mysql55-mysql-5.5.37-1.2.el6.centos.alt.x86_64.r | 5.7 MB     00:13    
(6/12): mysql55-mysql-libs-5.5.37-1.2.el6.centos.alt.x86 | 217 kB     00:01    
(7/12): mysql55-mysql-server-5.5.37-1.2.el6.centos.alt.x |  10 MB     00:17    
(8/12): mysql55-runtime-1-14.el6.centos.alt.x86_64.rpm   | 1.0 MB     00:01    
(9/12): perl-DBD-MySQL-4.013-3.el6.x86_64.rpm            | 134 kB     00:00    
(10/12): policycoreutils-python-2.0.83-19.39.el6.x86_64. | 343 kB     00:00    
(11/12): setools-libs-3.3.7-4.el6.x86_64.rpm             | 400 kB     00:00    
(12/12): setools-libs-python-3.3.7-4.el6.x86_64.rpm      | 222 kB     00:00    
--------------------------------------------------------------------------------
Total                                           448 kB/s |  19 MB     00:42    
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
  Updating   : audit-libs-2.2-4.el6_5.x86_64                               1/14
  Installing : audit-libs-python-2.2-4.el6_5.x86_64                        2/14
  Installing : setools-libs-3.3.7-4.el6.x86_64                             3/14
  Installing : setools-libs-python-3.3.7-4.el6.x86_64                      4/14
  Installing : perl-DBD-MySQL-4.013-3.el6.x86_64                           5/14
  Installing : libsemanage-python-2.0.43-4.2.el6.x86_64                    6/14
  Installing : policycoreutils-python-2.0.83-19.39.el6.x86_64              7/14
  Installing : mysql55-runtime-1-14.el6.centos.alt.x86_64                  8/14
  Installing : mysql55-mysql-libs-5.5.37-1.2.el6.centos.alt.x86_64         9/14
  Installing : mysql55-mysql-5.5.37-1.2.el6.centos.alt.x86_64             10/14
  Installing : mysql55-mysql-server-5.5.37-1.2.el6.centos.alt.x86_64      11/14
  Updating   : audit-2.2-4.el6_5.x86_64                                   12/14
  Cleanup    : audit-2.2-2.el6.x86_64                                     13/14
  Cleanup    : audit-libs-2.2-2.el6.x86_64                                14/14
  Verifying  : libsemanage-python-2.0.43-4.2.el6.x86_64                    1/14
  Verifying  : mysql55-runtime-1-14.el6.centos.alt.x86_64                  2/14
  Verifying  : perl-DBD-MySQL-4.013-3.el6.x86_64                           3/14
  Verifying  : audit-libs-python-2.2-4.el6_5.x86_64                        4/14
  Verifying  : setools-libs-python-3.3.7-4.el6.x86_64                      5/14
  Verifying  : mysql55-mysql-5.5.37-1.2.el6.centos.alt.x86_64              6/14
  Verifying  : audit-libs-2.2-4.el6_5.x86_64                               7/14
  Verifying  : policycoreutils-python-2.0.83-19.39.el6.x86_64              8/14
  Verifying  : mysql55-mysql-server-5.5.37-1.2.el6.centos.alt.x86_64       9/14
  Verifying  : audit-2.2-4.el6_5.x86_64                                   10/14
  Verifying  : setools-libs-3.3.7-4.el6.x86_64                            11/14
  Verifying  : mysql55-mysql-libs-5.5.37-1.2.el6.centos.alt.x86_64        12/14
  Verifying  : audit-libs-2.2-2.el6.x86_64                                13/14
  Verifying  : audit-2.2-2.el6.x86_64                                     14/14

Installed:
  mysql55-mysql-server.x86_64 0:5.5.37-1.2.el6.centos.alt                      

Dependency Installed:
  audit-libs-python.x86_64 0:2.2-4.el6_5                                       
  libsemanage-python.x86_64 0:2.0.43-4.2.el6                                   
  mysql55-mysql.x86_64 0:5.5.37-1.2.el6.centos.alt                             
  mysql55-mysql-libs.x86_64 0:5.5.37-1.2.el6.centos.alt                        
  mysql55-runtime.x86_64 0:1-14.el6.centos.alt                                 
  perl-DBD-MySQL.x86_64 0:4.013-3.el6                                          
  policycoreutils-python.x86_64 0:2.0.83-19.39.el6                             
  setools-libs.x86_64 0:3.3.7-4.el6                                            
  setools-libs-python.x86_64 0:3.3.7-4.el6                                     

Dependency Updated:
  audit.x86_64 0:2.2-4.el6_5           audit-libs.x86_64 0:2.2-4.el6_5         

Complete!

インストールが終わったので、MySQLを起動する。

# /etc/init.d/mysql55-mysqld start
MySQL データベースを初期化中:  WARNING: The host 'centos6' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
Installing MySQL system tables...
OK
Filling help tables...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/opt/rh/mysql55/root/usr/bin/mysqladmin -u root password 'new-password'
/opt/rh/mysql55/root/usr/bin/mysqladmin -u root -h centos6 password 'new-password'

Alternatively you can run:
/opt/rh/mysql55/root/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /opt/rh/mysql55/root/usr ; /opt/rh/mysql55/root/usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd /opt/rh/mysql55/root/usr/mysql-test ; perl mysql-test-run.pl

Please report any problems at http://bugs.mysql.com/

                                                           [  OK  ]
mysql55-mysqld を起動中:                                   [  OK  ]

その後、トラブル発生。

★MySQL5が起動しない問題の対応。

 リブート後にMySQL5が起動しなかった時のトラブルシュート。

$ mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

このエラーが出た場合は、いろいろの可能性が考えられる。
原因を探ると、MySQLが起動していない可能性が。
$ chkconfig --list | grep mysql
mysql55-mysqld     0:off    1:off    2:off    3:off    4:off    5:off    6:off

あかん…… ほんとうに動いてないぞっと。

# chkconfig mysqld on
サービス mysql に関する情報の読み込み中にエラーが発生しました: そのようなファイルやディレクトリはありません

ん????なんで???
ノーマルのMySQLとはちょっと違うのかな??

# chkconfig mysql55-mysqld on
# chkconfig --list | grep mysql
mysql55-mysqld     0:off    1:off    2:on    3:on    4:on    5:on    6:off

今度は大丈夫そう。リブートして確認してみる。
大丈夫、ちゃんと動いてる。

続いて、Mroongaをインストールする。

# yum install -y mysql55-mroonga
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
 * base: www.ftp.ne.jp
 * extras: www.ftp.ne.jp
 * updates: www.ftp.ne.jp
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql55-mroonga.x86_64 0:4.03-2.el6 will be installed
--> Processing Dependency: groonga-libs >= 4.0.0 for package: mysql55-mroonga-4.03-2.el6.x86_64
--> Processing Dependency: groonga-normalizer-mysql for package: mysql55-mroonga-4.03-2.el6.x86_64
--> Processing Dependency: libgroonga.so.0()(64bit) for package: mysql55-mroonga-4.03-2.el6.x86_64
--> Running transaction check
---> Package groonga-libs.x86_64 0:4.0.3-1.el6 will be installed
---> Package groonga-normalizer-mysql.x86_64 0:1.0.6-1.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package                       Arch        Version           Repository    Size
================================================================================
Installing:
 mysql55-mroonga               x86_64      4.03-2.el6        groonga      173 k
Installing for dependencies:
 groonga-libs                  x86_64      4.0.3-1.el6       groonga      1.0 M
 groonga-normalizer-mysql      x86_64      1.0.6-1.el6       groonga       63 k

Transaction Summary
================================================================================
Install       3 Package(s)

Total download size: 1.2 M
Installed size: 3.9 M
Downloading Packages:
(1/3): groonga-libs-4.0.3-1.el6.x86_64.rpm               | 1.0 MB     00:01    
(2/3): groonga-normalizer-mysql-1.0.6-1.el6.x86_64.rpm   |  63 kB     00:00    
(3/3): mysql55-mroonga-4.03-2.el6.x86_64.rpm             | 173 kB     00:00    
--------------------------------------------------------------------------------
Total                                           790 kB/s | 1.2 MB     00:01    
警告: rpmts_HdrFromFdno: ヘッダ V4 DSA/SHA1 Signature, key ID 45499429: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-groonga
Importing GPG key 0x45499429:
 Userid : groonga Key (groonga Official Signing Key)
 Package: groonga-release-1.1.0-1.noarch (installed)
 From   : /etc/pki/rpm-gpg/RPM-GPG-KEY-groonga
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : groonga-libs-4.0.3-1.el6.x86_64                              1/3
  Installing : groonga-normalizer-mysql-1.0.6-1.el6.x86_64                  2/3
  Installing : mysql55-mroonga-4.03-2.el6.x86_64                            3/3
/opt/rh/mysql55/root/usr/bin/mysql -u root < /opt/rh/mysql55/root/usr/share/mroonga/install.sql
  Verifying  : groonga-normalizer-mysql-1.0.6-1.el6.x86_64                  1/3
  Verifying  : groonga-libs-4.0.3-1.el6.x86_64                              2/3
  Verifying  : mysql55-mroonga-4.03-2.el6.x86_64                            3/3

Installed:
  mysql55-mroonga.x86_64 0:4.03-2.el6                                          

Dependency Installed:
  groonga-libs.x86_64 0:4.0.3-1.el6                                            
  groonga-normalizer-mysql.x86_64 0:1.0.6-1.el6                                

Complete!

トークナイザーにMeCabを使うので、インストールしておく。

# yum install -y groonga-tokenizer-mecab
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
 * base: www.ftp.ne.jp
 * extras: www.ftp.ne.jp
 * updates: www.ftp.ne.jp
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package groonga-tokenizer-mecab.x86_64 0:4.0.3-1.el6 will be installed
--> Processing Dependency: mecab-dic for package: groonga-tokenizer-mecab-4.0.3-1.el6.x86_64
--> Processing Dependency: libmecab.so.2()(64bit) for package: groonga-tokenizer-mecab-4.0.3-1.el6.x86_64
--> Running transaction check
---> Package mecab.x86_64 0:0.996-1.el6 will be installed
---> Package mecab-ipadic.x86_64 0:2.7.0.20070801-8.el6.1 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package                   Arch     Version                     Repository
                                                                           Size
================================================================================
Installing:
 groonga-tokenizer-mecab   x86_64   4.0.3-1.el6                 groonga    12 k
Installing for dependencies:
 mecab                     x86_64   0.996-1.el6                 groonga   2.3 M
 mecab-ipadic              x86_64   2.7.0.20070801-8.el6.1      groonga    13 M

Transaction Summary
================================================================================
Install       3 Package(s)

Total download size: 15 M
Installed size: 63 M
Downloading Packages:
(1/3): groonga-tokenizer-mecab-4.0.3-1.el6.x86_64.rpm    |  12 kB     00:00    
(2/3): mecab-0.996-1.el6.x86_64.rpm                      | 2.3 MB     00:02    
(3/3): mecab-ipadic-2.7.0.20070801-8.el6.1.x86_64.rpm    |  13 MB     00:14    
--------------------------------------------------------------------------------
Total                                           698 kB/s |  15 MB     00:22    
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : mecab-0.996-1.el6.x86_64                                     1/3
  Installing : mecab-ipadic-2.7.0.20070801-8.el6.1.x86_64                   2/3
  Installing : groonga-tokenizer-mecab-4.0.3-1.el6.x86_64                   3/3
  Verifying  : mecab-0.996-1.el6.x86_64                                     1/3
  Verifying  : mecab-ipadic-2.7.0.20070801-8.el6.1.x86_64                   2/3
  Verifying  : groonga-tokenizer-mecab-4.0.3-1.el6.x86_64                   3/3

Installed:
  groonga-tokenizer-mecab.x86_64 0:4.0.3-1.el6                                 

Dependency Installed:
  mecab.x86_64 0:0.996-1.el6    mecab-ipadic.x86_64 0:2.7.0.20070801-8.el6.1  

Complete!

途中にいろいろトラブルはあったけれど、とにかく、なんとかインストールは終わったようだ。
MySQL5のrootパスワードは変えておかねば。

$ mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.5.37 MySQL Community Server (GPL)

Copyright (c) 2000, 2013, 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> SET PASSWORD for root@localhost=PASSWORD('hogehoge');
Query OK, 0 rows affected (0.00 sec)

やっとここまで戻って来れた。
3歩進んで10歩下がった感じか。。。

CentOS6.5にMySQL5.5をインストールしたのだが。

さらに話は悲惨で、CentOS6.5にMySQL5をインストールしなくちゃならなくなった。
いままでブログに書いたやり方だと、MySQL5.6がインストールされてしまう事態に悩まされる。
同じことを2度繰り返したら成功したという顛末。

先人の教えに頼りつつ、こんな形で実現した。
まず最初に、MySQLのサイトから次の3ファイルをダウンロードしてくる。

MySQL-client-5.5.38-1.linux2.6.x86_64.rpm
MySQL-server-5.5.38-1.linux2.6.x86_64.rpm
MySQL-shared-compat-5.5.38-1.linux2.6.x86_64.rpm

で、まず既存のmysql関連のファイルを削除する。

# rpm -qa | grep mysql
mysql-devel-5.1.71-1.el6.x86_64
mysql-5.1.71-1.el6.x86_64

# yum remove mysql*
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package mysql.x86_64 0:5.1.71-1.el6 will be erased
---> Package mysql-devel.x86_64 0:5.1.71-1.el6 will be erased
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package     Arch   Version      Repository                                Size
================================================================================
Removing:
 mysql       x86_64 5.1.71-1.el6 @anaconda-CentOS-201311272149.x86_64/6.5 2.4 M
 mysql-devel x86_64 5.1.71-1.el6 @anaconda-CentOS-201311272149.x86_64/6.5 388 k

Transaction Summary
================================================================================
Remove        2 Package(s)

Installed size: 2.8 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Erasing    : mysql-devel-5.1.71-1.el6.x86_64                              1/2
  Erasing    : mysql-5.1.71-1.el6.x86_64                                    2/2
  Verifying  : mysql-5.1.71-1.el6.x86_64                                    1/2
  Verifying  : mysql-devel-5.1.71-1.el6.x86_64                              2/2

Removed:
  mysql.x86_64 0:5.1.71-1.el6         mysql-devel.x86_64 0:5.1.71-1.el6       

Complete!

で、あらためてインストール開始。
ライブラリーから。

# yum localinstall MySQL-shared-compat-5.5.38-1.linux2.6.x86_64
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Local Package Process
Skipping: MySQL-shared-compat-5.5.38-1.linux2.6.x86_64, filename does not end in .rpm.
Nothing to do

次にMySQL serverをインストール。

# yum localinstall MySQL-server-5.5.38-1.linux2.6.x86_64.rpm
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Local Package Process
Examining MySQL-server-5.5.38-1.linux2.6.x86_64.rpm: MySQL-server-5.5.38-1.linux2.6.x86_64
Marking MySQL-server-5.5.38-1.linux2.6.x86_64.rpm to be installed
Loading mirror speeds from cached hostfile
 * base: www.ftp.ne.jp
 * extras: www.ftp.ne.jp
 * updates: www.ftp.ne.jp
Resolving Dependencies
--> Running transaction check
---> Package MySQL-server.x86_64 0:5.5.38-1.linux2.6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package  Arch   Version           Repository                              Size
================================================================================
Installing:
 MySQL-server
          x86_64 5.5.38-1.linux2.6 /MySQL-server-5.5.38-1.linux2.6.x86_64 151 M

Transaction Summary
================================================================================
Install       1 Package(s)

Total size: 151 M
Installed size: 151 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : MySQL-server-5.5.38-1.linux2.6.x86_64                        1/1

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h CentOS6.5 password 'new-password'

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

Please report any problems at http://bugs.mysql.com/

  Verifying  : MySQL-server-5.5.38-1.linux2.6.x86_64                        1/1

Installed:
  MySQL-server.x86_64 0:5.5.38-1.linux2.6                                      

Complete!

そして最後にclientをインストール。

# yum localinstall MySQL-client-5.5.38-1.linux2.6.x86_64.rpm
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Local Package Process
Examining MySQL-client-5.5.38-1.linux2.6.x86_64.rpm: MySQL-client-5.5.38-1.linux2.6.x86_64
Marking MySQL-client-5.5.38-1.linux2.6.x86_64.rpm to be installed
Loading mirror speeds from cached hostfile
 * base: www.ftp.ne.jp
 * extras: www.ftp.ne.jp
 * updates: www.ftp.ne.jp
Resolving Dependencies
--> Running transaction check
---> Package MySQL-client.x86_64 0:5.5.38-1.linux2.6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package  Arch   Version           Repository                              Size
================================================================================
Installing:
 MySQL-client
          x86_64 5.5.38-1.linux2.6 /MySQL-client-5.5.38-1.linux2.6.x86_64  58 M

Transaction Summary
================================================================================
Install       1 Package(s)

Total size: 58 M
Installed size: 58 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : MySQL-client-5.5.38-1.linux2.6.x86_64                        1/1
  Verifying  : MySQL-client-5.5.38-1.linux2.6.x86_64                        1/1

Installed:
  MySQL-client.x86_64 0:5.5.38-1.linux2.6                                      

Complete!

一連のインストール作業は終了。
バージョンを確認してみる。

# mysql --version
mysql  Ver 14.14 Distrib 5.5.38, for Linux (x86_64) using readline 5.1

ちゃんとMySQL 5.5.38がインストールされているようだ。
じゃ、MySQLを起動してみる。

$ sudo service mysql start
Starting MySQL..                                           [  OK  ]

ちゃんと動いたので、CentOSが起動したときに、MySQLも自動起動するためのおまじない。

$ sudo chkconfig mysql on

じゃ、MySQLにアクセスしてみる。

$ mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.38 MySQL Community Server (GPL)

Copyright (c) 2000, 2014, 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> SET PASSWORD for root@localhost=PASSWORD('hogehoge');
Query OK, 0 rows affected (0.00 sec)

以上、終了。

CentOS6.5にMariaDBをインストールしたところ。

結局、CentOS7はいろいろと練れていないところが多すぎる気がする。
もっとバージョンが上がって落ち着きまでは、手を出しちゃいけないんだろうな。

というわけで、CentOS6.5に戻って、MariaDBのインストール作業を行う。
これからMySQLからMariaDBへ移行が進むらしいけれど、どんなものなのやら。

まず、既存のMySQLのパッケージの有無を調べる。

[root@centos6 hogehoge]# rpm -qa | grep mysql
mysql-libs-5.1.73-3.el6_5.x86_64
mysql-5.1.73-3.el6_5.x86_64
mysql-devel-5.1.73-3.el6_5.x86_64

これはデフォルトでインストールされているパッケージだね。
じゃ、これを削除する。

[root@centos6 hogehoge]# yum remove mysql*
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package mysql.x86_64 0:5.1.73-3.el6_5 will be erased
---> Package mysql-devel.x86_64 0:5.1.73-3.el6_5 will be erased
---> Package mysql-libs.x86_64 0:5.1.73-3.el6_5 will be erased
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: 2:postfix-2.6.6-6.el6_5.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: 2:postfix-2.6.6-6.el6_5.x86_64
--> Processing Dependency: mysql-libs for package: 2:postfix-2.6.6-6.el6_5.x86_64
--> Running transaction check
---> Package postfix.x86_64 2:2.6.6-6.el6_5 will be erased
--> Processing Dependency: /usr/sbin/sendmail for package: redhat-lsb-core-4.0-7.el6.centos.x86_64
--> Processing Dependency: /usr/sbin/sendmail for package: cronie-1.4.4-12.el6.x86_64
--> Running transaction check
---> Package cronie.x86_64 0:1.4.4-12.el6 will be erased
--> Processing Dependency: cronie = 1.4.4-12.el6 for package: cronie-anacron-1.4.4-12.el6.x86_64
---> Package redhat-lsb-core.x86_64 0:4.0-7.el6.centos will be erased
--> Processing Dependency: redhat-lsb-core(x86-64) = 4.0 for package: redhat-lsb-printing-4.0-7.el6.centos.x86_64
--> Processing Dependency: redhat-lsb-core(x86-64) = 4.0-7.el6.centos for package: redhat-lsb-4.0-7.el6.centos.x86_64
--> Processing Dependency: redhat-lsb-core(x86-64) = 4.0 for package: redhat-lsb-graphics-4.0-7.el6.centos.x86_64
--> Running transaction check
---> Package cronie-anacron.x86_64 0:1.4.4-12.el6 will be erased
---> Package redhat-lsb.x86_64 0:4.0-7.el6.centos will be erased
--> Processing Dependency: redhat-lsb(x86-64) = 4.0-7.el6.centos for package: redhat-lsb-compat-4.0-7.el6.centos.x86_64
---> Package redhat-lsb-graphics.x86_64 0:4.0-7.el6.centos will be erased
---> Package redhat-lsb-printing.x86_64 0:4.0-7.el6.centos will be erased
--> Running transaction check
---> Package redhat-lsb-compat.x86_64 0:4.0-7.el6.centos will be erased
--> Processing Dependency: /etc/cron.d for package: crontabs-1.10-33.el6.noarch
--> Processing Dependency: /etc/cron.d for package: sysstat-9.0.4-22.el6.x86_64
--> Restarting Dependency Resolution with new changes.
--> Running transaction check
---> Package crontabs.noarch 0:1.10-33.el6 will be erased
---> Package sysstat.x86_64 0:9.0.4-22.el6 will be erased
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package Arch   Version          Repository                                Size
================================================================================
Removing:
 mysql   x86_64 5.1.73-3.el6_5   @updates                                 2.4 M
 mysql-devel
         x86_64 5.1.73-3.el6_5   @updates                                 388 k
 mysql-libs
         x86_64 5.1.73-3.el6_5   @updates                                 4.0 M
Removing for dependencies:
 cronie  x86_64 1.4.4-12.el6     @anaconda-CentOS-201311272149.x86_64/6.5 174 k
 cronie-anacron
         x86_64 1.4.4-12.el6     @anaconda-CentOS-201311272149.x86_64/6.5  43 k
 crontabs
         noarch 1.10-33.el6      @anaconda-CentOS-201311272149.x86_64/6.5 2.4 k
 postfix x86_64 2:2.6.6-6.el6_5  @updates                                 9.7 M
 redhat-lsb
         x86_64 4.0-7.el6.centos @anaconda-CentOS-201311272149.x86_64/6.5 0.0 
 redhat-lsb-compat
         x86_64 4.0-7.el6.centos @anaconda-CentOS-201311272149.x86_64/6.5 0.0 
 redhat-lsb-core
         x86_64 4.0-7.el6.centos @anaconda-CentOS-201311272149.x86_64/6.5  22 k
 redhat-lsb-graphics
         x86_64 4.0-7.el6.centos @anaconda-CentOS-201311272149.x86_64/6.5 0.0 
 redhat-lsb-printing
         x86_64 4.0-7.el6.centos @anaconda-CentOS-201311272149.x86_64/6.5 0.0 
 sysstat x86_64 9.0.4-22.el6     @anaconda-CentOS-201311272149.x86_64/6.5 824 k

Transaction Summary
================================================================================
Remove       13 Package(s)

Installed size: 18 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Erasing    : redhat-lsb-compat-4.0-7.el6.centos.x86_64                   1/13
  Erasing    : redhat-lsb-4.0-7.el6.centos.x86_64                          2/13
  Erasing    : mysql-devel-5.1.73-3.el6_5.x86_64                           3/13
  Erasing    : redhat-lsb-graphics-4.0-7.el6.centos.x86_64                 4/13
  Erasing    : redhat-lsb-printing-4.0-7.el6.centos.x86_64                 5/13
  Erasing    : redhat-lsb-core-4.0-7.el6.centos.x86_64                     6/13
  Erasing    : mysql-5.1.73-3.el6_5.x86_64                                 7/13
/var/tmp/rpm-tmp.OHPbrg: line 1: lsb_release: コマンドが見つかりません
  Erasing    : sysstat-9.0.4-22.el6.x86_64                                 8/13
  Erasing    : crontabs-1.10-33.el6.noarch                                 9/13
  Erasing    : cronie-anacron-1.4.4-12.el6.x86_64                         10/13
  Erasing    : cronie-1.4.4-12.el6.x86_64                                 11/13
  Erasing    : 2:postfix-2.6.6-6.el6_5.x86_64                             12/13
  Erasing    : mysql-libs-5.1.73-3.el6_5.x86_64                           13/13
  Verifying  : mysql-devel-5.1.73-3.el6_5.x86_64                           1/13
  Verifying  : redhat-lsb-printing-4.0-7.el6.centos.x86_64                 2/13
  Verifying  : cronie-anacron-1.4.4-12.el6.x86_64                          3/13
  Verifying  : redhat-lsb-core-4.0-7.el6.centos.x86_64                     4/13
  Verifying  : mysql-libs-5.1.73-3.el6_5.x86_64                            5/13
  Verifying  : redhat-lsb-4.0-7.el6.centos.x86_64                          6/13
  Verifying  : mysql-5.1.73-3.el6_5.x86_64                                 7/13
  Verifying  : crontabs-1.10-33.el6.noarch                                 8/13
  Verifying  : redhat-lsb-compat-4.0-7.el6.centos.x86_64                   9/13
  Verifying  : sysstat-9.0.4-22.el6.x86_64                                10/13
  Verifying  : cronie-1.4.4-12.el6.x86_64                                 11/13
  Verifying  : 2:postfix-2.6.6-6.el6_5.x86_64                             12/13
  Verifying  : redhat-lsb-graphics-4.0-7.el6.centos.x86_64                13/13

Removed:
  mysql.x86_64 0:5.1.73-3.el6_5          mysql-devel.x86_64 0:5.1.73-3.el6_5   
  mysql-libs.x86_64 0:5.1.73-3.el6_5   

Dependency Removed:
  cronie.x86_64 0:1.4.4-12.el6                                                 
  cronie-anacron.x86_64 0:1.4.4-12.el6                                         
  crontabs.noarch 0:1.10-33.el6                                                
  postfix.x86_64 2:2.6.6-6.el6_5                                               
  redhat-lsb.x86_64 0:4.0-7.el6.centos                                         
  redhat-lsb-compat.x86_64 0:4.0-7.el6.centos                                  
  redhat-lsb-core.x86_64 0:4.0-7.el6.centos                                    
  redhat-lsb-graphics.x86_64 0:4.0-7.el6.centos                                
  redhat-lsb-printing.x86_64 0:4.0-7.el6.centos                                
  sysstat.x86_64 0:9.0.4-22.el6                                                

Complete!
[root@centos6 hogehoge]# rpm -qa | grep mysql
[root@centos6 hogehoge]#

きれいさっぱりなくなりました。

で、MariaDBのインストールに取りかかる。
まず最初に、RPG-GPG-KEYを追加する

[root@centos6 hogehoge]# sudo rpm --import https://yum.mariadb.org/RPM-GPG-KEY-MariaDB

次に、リポジトリを追加作業を実施。
今回はバージョン10.0.12にトライ!

[root@centos6 hogehoge]# vi /etc/yum.repos.d/MariaDB.repo

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.0.12/centos6-x86
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
enabled=1

リポジトリの追加作業が終わったら、インストールを実行。

[root@centos6 hogehoge]# yum install MariaDB-devel MariaDB-client MariaDB-server
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
 * base: www.ftp.ne.jp
 * extras: www.ftp.ne.jp
 * updates: www.ftp.ne.jp
mariadb                                                  | 1.9 kB     00:00    
mariadb/primary_db                                       |  18 kB     00:00    
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-client.i686 0:10.0.12-1.el6 will be installed
--> Processing Dependency: MariaDB-common for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libtinfo.so.5 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libcrypt.so.1 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libdl.so.2(GLIBC_2.0) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libcrypt.so.1(GLIBC_2.0) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: ld-linux.so.2 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libpthread.so.0(GLIBC_2.3.2) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libc.so.6(GLIBC_2.3.3) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libm.so.6(GLIBC_2.0) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libaio.so.1 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: librt.so.1(GLIBC_2.2) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libstdc++.so.6 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libc.so.6(GLIBC_2.2) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libm.so.6 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libc.so.6(GLIBC_2.0) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: librt.so.1 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libm.so.6(GLIBC_2.1) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libdl.so.2 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libpthread.so.0(GLIBC_2.2) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libpthread.so.0 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libc.so.6(GLIBC_2.3) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libaio.so.1(LIBAIO_0.4) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libstdc++.so.6(GLIBCXX_3.4) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libaio.so.1(LIBAIO_0.1) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libc.so.6(GLIBC_2.1.3) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libpthread.so.0(GLIBC_2.1) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libncurses.so.5 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: ld-linux.so.2(GLIBC_2.3) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libcrypto.so.10 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libstdc++.so.6(CXXABI_1.3) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libpthread.so.0(GLIBC_2.0) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libdl.so.2(GLIBC_2.1) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libc.so.6 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libssl.so.10 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libz.so.1 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libm.so.6(GLIBC_2.2) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libc.so.6(GLIBC_2.1) for package: MariaDB-client-10.0.12-1.el6.i686
---> Package MariaDB-devel.i686 0:10.0.12-1.el6 will be installed
---> Package MariaDB-server.i686 0:10.0.12-1.el6 will be installed
--> Processing Dependency: libpam.so.0(LIBPAM_1.0) for package: MariaDB-server-10.0.12-1.el6.i686
--> Processing Dependency: libpam.so.0 for package: MariaDB-server-10.0.12-1.el6.i686
--> Running transaction check
---> Package MariaDB-common.i686 0:10.0.12-1.el6 will be installed
--> Processing Dependency: MariaDB-compat for package: MariaDB-common-10.0.12-1.el6.i686
---> Package glibc.i686 0:2.12-1.132.el6_5.2 will be installed
--> Processing Dependency: libfreebl3.so(NSSRAWHASH_3.12.3) for package: glibc-2.12-1.132.el6_5.2.i686
--> Processing Dependency: libfreebl3.so for package: glibc-2.12-1.132.el6_5.2.i686
---> Package libaio.i686 0:0.3.107-10.el6 will be installed
---> Package libstdc++.i686 0:4.4.7-4.el6 will be installed
--> Processing Dependency: libgcc_s.so.1(GLIBC_2.0) for package: libstdc++-4.4.7-4.el6.i686
--> Processing Dependency: libgcc_s.so.1(GCC_4.2.0) for package: libstdc++-4.4.7-4.el6.i686
--> Processing Dependency: libgcc_s.so.1(GCC_3.3) for package: libstdc++-4.4.7-4.el6.i686
--> Processing Dependency: libgcc_s.so.1(GCC_3.0) for package: libstdc++-4.4.7-4.el6.i686
--> Processing Dependency: libgcc_s.so.1 for package: libstdc++-4.4.7-4.el6.i686
---> Package ncurses-libs.i686 0:5.7-3.20090208.el6 will be installed
---> Package openssl.i686 0:1.0.1e-16.el6_5.14 will be installed
--> Processing Dependency: libkrb5.so.3(krb5_3_MIT) for package: openssl-1.0.1e-16.el6_5.14.i686
--> Processing Dependency: libkrb5.so.3 for package: openssl-1.0.1e-16.el6_5.14.i686
--> Processing Dependency: libk5crypto.so.3(k5crypto_3_MIT) for package: openssl-1.0.1e-16.el6_5.14.i686
--> Processing Dependency: libk5crypto.so.3 for package: openssl-1.0.1e-16.el6_5.14.i686
--> Processing Dependency: libgssapi_krb5.so.2 for package: openssl-1.0.1e-16.el6_5.14.i686
--> Processing Dependency: libcom_err.so.2 for package: openssl-1.0.1e-16.el6_5.14.i686
---> Package pam.i686 0:1.1.1-17.el6 will be installed
--> Processing Dependency: libselinux.so.1 for package: pam-1.1.1-17.el6.i686
--> Processing Dependency: libdb-4.7.so for package: pam-1.1.1-17.el6.i686
--> Processing Dependency: libcrack.so.2 for package: pam-1.1.1-17.el6.i686
--> Processing Dependency: libaudit.so.1 for package: pam-1.1.1-17.el6.i686
---> Package zlib.i686 0:1.2.3-29.el6 will be installed
--> Running transaction check
---> Package MariaDB-compat.i686 0:10.0.12-1.el6 will be installed
---> Package audit-libs.i686 0:2.2-4.el6_5 will be installed
---> Package cracklib.i686 0:2.8.16-4.el6 will be installed
---> Package db4.i686 0:4.7.25-18.el6_4 will be installed
---> Package krb5-libs.i686 0:1.10.3-15.el6_5.1 will be installed
--> Processing Dependency: libkeyutils.so.1(KEYUTILS_0.3) for package: krb5-libs-1.10.3-15.el6_5.1.i686
--> Processing Dependency: libkeyutils.so.1 for package: krb5-libs-1.10.3-15.el6_5.1.i686
---> Package libcom_err.i686 0:1.41.12-18.el6 will be installed
---> Package libgcc.i686 0:4.4.7-4.el6 will be installed
---> Package libselinux.i686 0:2.0.94-5.3.el6_4.1 will be installed
---> Package nss-softokn-freebl.i686 0:3.14.3-10.el6_5 will be installed
--> Running transaction check
---> Package keyutils-libs.i686 0:1.4-4.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package                 Arch      Version                   Repository    Size
================================================================================
Installing:
 MariaDB-client          i686      10.0.12-1.el6             mariadb       11 M
 MariaDB-devel           i686      10.0.12-1.el6             mariadb      6.4 M
 MariaDB-server          i686      10.0.12-1.el6             mariadb       40 M
Installing for dependencies:
 MariaDB-common          i686      10.0.12-1.el6             mariadb       23 k
 MariaDB-compat          i686      10.0.12-1.el6             mariadb      2.6 M
 audit-libs              i686      2.2-4.el6_5               updates       61 k
 cracklib                i686      2.8.16-4.el6              base          70 k
 db4                     i686      4.7.25-18.el6_4           base         580 k
 glibc                   i686      2.12-1.132.el6_5.2        updates      4.3 M
 keyutils-libs           i686      1.4-4.el6                 base          20 k
 krb5-libs               i686      1.10.3-15.el6_5.1         updates      769 k
 libaio                  i686      0.3.107-10.el6            base          21 k
 libcom_err              i686      1.41.12-18.el6            base          37 k
 libgcc                  i686      4.4.7-4.el6               base         112 k
 libselinux              i686      2.0.94-5.3.el6_4.1        base         108 k
 libstdc++               i686      4.4.7-4.el6               base         300 k
 ncurses-libs            i686      5.7-3.20090208.el6        base         251 k
 nss-softokn-freebl      i686      3.14.3-10.el6_5           updates      147 k
 openssl                 i686      1.0.1e-16.el6_5.14        updates      1.5 M
 pam                     i686      1.1.1-17.el6              base         659 k
 zlib                    i686      1.2.3-29.el6              base          73 k

Transaction Summary
================================================================================
Install      21 Package(s)

Total download size: 69 M
Installed size: 264 M
Is this ok [y/N]: y
Downloading Packages:
(1/21): MariaDB-10.0.12-centos6-i686-client.rpm          |  11 MB     00:23    
(2/21): MariaDB-10.0.12-centos6-i686-common.rpm          |  23 kB     00:00    
(3/21): MariaDB-10.0.12-centos6-i686-compat.rpm          | 2.6 MB     00:07    
(4/21): MariaDB-10.0.12-centos6-i686-devel.rpm           | 6.4 MB     00:28    
(5/21): MariaDB-10.0.12-centos6-i686-server.rpm          |  40 MB     03:40    
(6/21): audit-libs-2.2-4.el6_5.i686.rpm                  |  61 kB     00:00    
(7/21): cracklib-2.8.16-4.el6.i686.rpm                   |  70 kB     00:00    
(8/21): db4-4.7.25-18.el6_4.i686.rpm                     | 580 kB     00:01    
(9/21): glibc-2.12-1.132.el6_5.2.i686.rpm                | 4.3 MB     00:10    
(10/21): keyutils-libs-1.4-4.el6.i686.rpm                |  20 kB     00:00    
(11/21): krb5-libs-1.10.3-15.el6_5.1.i686.rpm            | 769 kB     00:02    
(12/21): libaio-0.3.107-10.el6.i686.rpm                  |  21 kB     00:00    
(13/21): libcom_err-1.41.12-18.el6.i686.rpm              |  37 kB     00:00    
(14/21): libgcc-4.4.7-4.el6.i686.rpm                     | 112 kB     00:00    
(15/21): libselinux-2.0.94-5.3.el6_4.1.i686.rpm          | 108 kB     00:00    
(16/21): libstdc++-4.4.7-4.el6.i686.rpm                  | 300 kB     00:00    
(17/21): ncurses-libs-5.7-3.20090208.el6.i686.rpm        | 251 kB     00:00    
(18/21): nss-softokn-freebl-3.14.3-10.el6_5.i686.rpm     | 147 kB     00:00    
(19/21): openssl-1.0.1e-16.el6_5.14.i686.rpm             | 1.5 MB     00:04    
(20/21): pam-1.1.1-17.el6.i686.rpm                       | 659 kB     00:02    
(21/21): zlib-1.2.3-29.el6.i686.rpm                      |  73 kB     00:00    
--------------------------------------------------------------------------------
Total                                           228 kB/s |  69 MB     05:07    
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : libgcc-4.4.7-4.el6.i686                                     1/21
  Installing : glibc-2.12-1.132.el6_5.2.i686                               2/21
  Installing : nss-softokn-freebl-3.14.3-10.el6_5.i686                     3/21
  Installing : zlib-1.2.3-29.el6.i686                                      4/21
  Installing : libstdc++-4.4.7-4.el6.i686                                  5/21
  Installing : libselinux-2.0.94-5.3.el6_4.1.i686                          6/21
  Installing : libcom_err-1.41.12-18.el6.i686                              7/21
  Installing : libaio-0.3.107-10.el6.i686                                  8/21
  Installing : MariaDB-compat-10.0.12-1.el6.i686                           9/21
  Installing : MariaDB-common-10.0.12-1.el6.i686                          10/21
  Installing : cracklib-2.8.16-4.el6.i686                                 11/21
  Installing : keyutils-libs-1.4-4.el6.i686                               12/21
  Installing : krb5-libs-1.10.3-15.el6_5.1.i686                           13/21
  Installing : openssl-1.0.1e-16.el6_5.14.i686                            14/21
  Installing : audit-libs-2.2-4.el6_5.i686                                15/21
  Installing : ncurses-libs-5.7-3.20090208.el6.i686                       16/21
  Installing : MariaDB-client-10.0.12-1.el6.i686                          17/21
  Installing : db4-4.7.25-18.el6_4.i686                                   18/21
  Installing : MariaDB-devel-10.0.12-1.el6.i686                           19/21
  Installing : pam-1.1.1-17.el6.i686                                      20/21
  Installing : MariaDB-server-10.0.12-1.el6.i686                          21/21
chown: cannot access `/var/lib/mysql': そのようなファイルやディレクトリはありません
140720 20:42:53 [Note] InnoDB: Using mutexes to ref count buffer pool pages
140720 20:42:53 [Note] InnoDB: The InnoDB memory heap is disabled
140720 20:42:53 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
140720 20:42:53 [Note] InnoDB: Compressed tables use zlib 1.2.3
140720 20:42:53 [Note] InnoDB: Using Linux native AIO
140720 20:42:53 [Note] InnoDB: Not using CPU crc32 instructions
140720 20:42:53 [Note] InnoDB: Initializing buffer pool, size = 128.0M
140720 20:42:53 [Note] InnoDB: Completed initialization of buffer pool
140720 20:42:53 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
140720 20:42:53 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
140720 20:42:53 [Note] InnoDB: Database physically writes the file full: wait...
140720 20:42:53 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
140720 20:42:54 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
140720 20:42:54 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
140720 20:42:54 [Warning] InnoDB: New log files created, LSN=45781
140720 20:42:54 [Note] InnoDB: Doublewrite buffer not found: creating new
140720 20:42:54 [Note] InnoDB: Doublewrite buffer created
140720 20:42:54 [Note] InnoDB: 128 rollback segment(s) are active.
140720 20:42:54 [Warning] InnoDB: Creating foreign key constraint system tables.
140720 20:42:54 [Note] InnoDB: Foreign key constraint system tables created
140720 20:42:54 [Note] InnoDB: Creating tablespace and datafile system tables.
140720 20:42:54 [Note] InnoDB: Tablespace and datafile system tables created.
140720 20:42:54 [Note] InnoDB: Waiting for purge to start
140720 20:42:54 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.17-65.0 started; log sequence number 0
140720 20:42:55 [Note] InnoDB: FTS optimize thread exiting.
140720 20:42:55 [Note] InnoDB: Starting shutdown...
140720 20:42:57 [Note] InnoDB: Shutdown completed; log sequence number 1616697
140720 20:42:57 [Note] InnoDB: Using mutexes to ref count buffer pool pages
140720 20:42:57 [Note] InnoDB: The InnoDB memory heap is disabled
140720 20:42:57 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
140720 20:42:57 [Note] InnoDB: Compressed tables use zlib 1.2.3
140720 20:42:57 [Note] InnoDB: Using Linux native AIO
140720 20:42:57 [Note] InnoDB: Not using CPU crc32 instructions
140720 20:42:57 [Note] InnoDB: Initializing buffer pool, size = 128.0M
140720 20:42:57 [Note] InnoDB: Completed initialization of buffer pool
140720 20:42:57 [Note] InnoDB: Highest supported file format is Barracuda.
140720 20:42:57 [Note] InnoDB: 128 rollback segment(s) are active.
140720 20:42:57 [Note] InnoDB: Waiting for purge to start
140720 20:42:57 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.17-65.0 started; log sequence number 1616697
140720 20:42:57 [Note] InnoDB: FTS optimize thread exiting.
140720 20:42:57 [Note] InnoDB: Starting shutdown...
140720 20:42:59 [Note] InnoDB: Shutdown completed; log sequence number 1616707

PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following commands:

'/usr/bin/mysqladmin' -u root password 'new-password'
'/usr/bin/mysqladmin' -u root -h centos6.5 password 'new-password'

Alternatively you can run:
'/usr/bin/mysql_secure_installation'

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the MariaDB Knowledgebase at http://mariadb.com/kb or the
MySQL manual for more instructions.

Please report any problems at http://mariadb.org/jira

The latest information about MariaDB is available at http://mariadb.org/.
You can find additional information about the MySQL part at:
http://dev.mysql.com
Support MariaDB development by buying support/new features from
SkySQL Ab. You can contact us about this at sales@skysql.com.
Alternatively consider joining our community based development effort:
http://mariadb.com/kb/en/contributing-to-the-mariadb-project/

  Verifying  : cracklib-2.8.16-4.el6.i686                                  1/21
  Verifying  : libstdc++-4.4.7-4.el6.i686                                  2/21
  Verifying  : MariaDB-client-10.0.12-1.el6.i686                           3/21
  Verifying  : MariaDB-common-10.0.12-1.el6.i686                           4/21
  Verifying  : libselinux-2.0.94-5.3.el6_4.1.i686                          5/21
  Verifying  : libcom_err-1.41.12-18.el6.i686                              6/21
  Verifying  : nss-softokn-freebl-3.14.3-10.el6_5.i686                     7/21
  Verifying  : MariaDB-devel-10.0.12-1.el6.i686                            8/21
  Verifying  : keyutils-libs-1.4-4.el6.i686                                9/21
  Verifying  : libgcc-4.4.7-4.el6.i686                                    10/21
  Verifying  : audit-libs-2.2-4.el6_5.i686                                11/21
  Verifying  : ncurses-libs-5.7-3.20090208.el6.i686                       12/21
  Verifying  : libaio-0.3.107-10.el6.i686                                 13/21
  Verifying  : MariaDB-server-10.0.12-1.el6.i686                          14/21
  Verifying  : MariaDB-compat-10.0.12-1.el6.i686                          15/21
  Verifying  : pam-1.1.1-17.el6.i686                                      16/21
  Verifying  : db4-4.7.25-18.el6_4.i686                                   17/21
  Verifying  : openssl-1.0.1e-16.el6_5.14.i686                            18/21
  Verifying  : krb5-libs-1.10.3-15.el6_5.1.i686                           19/21
  Verifying  : glibc-2.12-1.132.el6_5.2.i686                              20/21
  Verifying  : zlib-1.2.3-29.el6.i686                                     21/21

Installed:
  MariaDB-client.i686 0:10.0.12-1.el6     MariaDB-devel.i686 0:10.0.12-1.el6   
  MariaDB-server.i686 0:10.0.12-1.el6   

Dependency Installed:
  MariaDB-common.i686 0:10.0.12-1.el6                                          
  MariaDB-compat.i686 0:10.0.12-1.el6                                          
  audit-libs.i686 0:2.2-4.el6_5                                                
  cracklib.i686 0:2.8.16-4.el6                                                 
  db4.i686 0:4.7.25-18.el6_4                                                   
  glibc.i686 0:2.12-1.132.el6_5.2                                              
  keyutils-libs.i686 0:1.4-4.el6                                               
  krb5-libs.i686 0:1.10.3-15.el6_5.1                                           
  libaio.i686 0:0.3.107-10.el6                                                 
  libcom_err.i686 0:1.41.12-18.el6                                             
  libgcc.i686 0:4.4.7-4.el6                                                    
  libselinux.i686 0:2.0.94-5.3.el6_4.1                                         
  libstdc++.i686 0:4.4.7-4.el6                                                 
  ncurses-libs.i686 0:5.7-3.20090208.el6                                       
  nss-softokn-freebl.i686 0:3.14.3-10.el6_5                                    
  openssl.i686 0:1.0.1e-16.el6_5.14                                            
  pam.i686 0:1.1.1-17.el6                                                      
  zlib.i686 0:1.2.3-29.el6                                                     

Complete!

で、MariaDB関連のインストールは終わったらしい。
バージョンを確認してみると。

[root@centos6 /]# mysqld --version
mysqld  Ver 10.0.12-MariaDB for Linux on i686 (MariaDB Server)

MySQLでありながらMariaDBという、この気持ち悪さはなんなんだ!? (^^;
で、MariaDBを起動させる。

[root@centos6 /]# sudo service mysql start
Starting MySQL. SUCCESS!

ついでに、CentOS6.5起動時にMariaDBを自動起動するためのまじないも。

[root@centos6 /]# sudo chkconfig mysql on

じゃ、動作確認してみますか.

[hogehoge@centos6 ~]$ mysql -u root
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.0.12-MariaDB MariaDB Server

Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

rootのパスワードを変更しておこう。

MariaDB [(none)]> SET PASSWORD for root@localhost=PASSWORD('hogehoge');
Query OK, 0 rows affected (0.04 sec)

これでrootのパスワードが設定された。
MariaDBのインストールはここまで。