CentOS5.8にMySQL5.5をインストールする

2012年11月9日 Posted by PURGE

久しぶりにサーバ構築することとなり、CentOS5.8にMySQL5.5をインストールしようとする。

以前の記事から、既に1年以上が経って、もはやその通りに動作していないことに気付く。

再度覚え書きとする。

■yum レポジトリの追加

wget http://dl.iuscommunity.org/pub/ius/stable/Redhat/5/x86_64/ius-release-1.0-10.ius.el5.noarch.rpm
wget http://dl.iuscommunity.org/pub/ius/stable/Redhat/5/x86_64/epel-release-5-4.noarch.rpm

rpm -Uvh epel-release-5-4.noarch.rpm
警告: epel-release-5-4.noarch.rpm: ヘッダ V4 DSA signature: NOKEY, key ID 9cd4953f
準備中...                ########################################### [100%]
   1:epel-release           ########################################### [100%]
rpm -Uvh ius-release-1.0-10.ius.el5.noarch.rpm
警告: ius-release-1.0-10.ius.el5.noarch.rpm: ヘッダ V4 DSA signature: NOKEY, key ID 9cd4953f
準備中...                ########################################### [100%]
   1:ius-release            ########################################### [100%]

■ius,epelからのインストール。

yum --enablerepo=ius,epel install mysql
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: ftp.oss.eznetsols.org
 * epel: ftp.iij.ad.jp
 * extras: ftp.oss.eznetsols.org
 * ius: archive.linux.duke.edu
 * updates: ftp.oss.eznetsols.org
epel                                                                          | 3.7 kB     00:00
epel/primary_db                                                               | 3.8 MB     00:00
ius                                                                           | 2.2 kB     00:00
ius/primary_db                                                                | 166 kB     00:00
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql.i386 0:5.0.95-1.el5_7.1 set to be updated
---> Package mysql.x86_64 0:5.0.95-1.el5_7.1 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

=====================================================================================================
 Package             Arch                 Version                        Repository             Size
=====================================================================================================
Installing:
 mysql               i386                 5.0.95-1.el5_7.1               updates               4.9 M
 mysql               x86_64               5.0.95-1.el5_7.1               updates               4.9 M

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

Total download size: 9.8 M

残念ながら、5.0のままなので、No!!

Is this ok [y/N]: N
Exiting on user Command
Complete!

■再度バージョン指定して実行。

yum --enablerepo=ius,epel install mysql55
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: ftp.oss.eznetsols.org
 * epel: ftp.iij.ad.jp
 * extras: ftp.oss.eznetsols.org
 * ius: archive.linux.duke.edu
 * updates: ftp.oss.eznetsols.org
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql55.x86_64 0:5.5.28-2.ius.el5 set to be updated
--> Processing Dependency: mysql55-libs = 5.5.28-2.ius.el5 for package: mysql55
--> Processing Dependency: mysqlclient15 for package: mysql55
--> Running transaction check
---> Package mysql55-libs.x86_64 0:5.5.28-2.ius.el5 set to be updated
---> Package mysqlclient15.x86_64 0:5.0.92-3.ius.el5 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

=====================================================================================================
 Package                    Arch                Version                       Repository        Size
=====================================================================================================
Installing:
 mysql55                    x86_64              5.5.28-2.ius.el5              ius               11 M
Installing for dependencies:
 mysql55-libs               x86_64              5.5.28-2.ius.el5              ius              1.1 M
 mysqlclient15              x86_64              5.0.92-3.ius.el5              ius              1.7 M

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

Total download size: 14 M
Is this ok [y/N]: y
Downloading Packages:
(1/3): mysql55-libs-5.5.28-2.ius.el5.x86_64.rpm                               | 1.1 MB     00:01
(2/3): mysqlclient15-5.0.92-3.ius.el5.x86_64.rpm                              | 1.7 MB     00:00
(3/3): mysql55-5.5.28-2.ius.el5.x86_64.rpm                                    |  11 MB     00:02
-----------------------------------------------------------------------------------------------------
Total                                                                2.4 MB/s |  14 MB     00:05
警告: rpmts_HdrFromFdno: ヘッダ V4 DSA signature: NOKEY, key ID 9cd4953f
ius/gpgkey                                                                    | 1.3 kB     00:00
Importing GPG key 0x9CD4953F "IUS Community Project <coredev@iuscommunity.org>" from /etc/pki/rpm-gpg/IUS-COMMUNITY-GPG-KEY
Is this ok [y/N]: y
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing     : mysqlclient15                                                                 1/3
  Installing     : mysql55-libs                                                                  2/3
  Installing     : mysql55                                                                       3/3

Installed:
  mysql55.x86_64 0:5.5.28-2.ius.el5

Dependency Installed:
  mysql55-libs.x86_64 0:5.5.28-2.ius.el5           mysqlclient15.x86_64 0:5.0.92-3.ius.el5

Complete!

mysql-server55 が足りなかったようだ。

yum --enablerepo=ius,epel install mysql55-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: ftp.oss.eznetsols.org
 * epel: ftp.iij.ad.jp
 * extras: ftp.oss.eznetsols.org
 * ius: archive.linux.duke.edu
 * updates: ftp.oss.eznetsols.org
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql55-server.x86_64 0:5.5.28-2.ius.el5 set to be updated
--> Processing Dependency: perl-DBD-MySQL for package: mysql55-server
--> Running transaction check
---> Package perl-DBD-MySQL.x86_64 0:3.0007-2.el5 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

=====================================================================================================
 Package                    Arch               Version                        Repository        Size
=====================================================================================================
Installing:
 mysql55-server             x86_64             5.5.28-2.ius.el5               ius               12 M
Installing for dependencies:
 perl-DBD-MySQL             x86_64             3.0007-2.el5                   base             148 k

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

Total download size: 12 M
Is this ok [y/N]: y
Downloading Packages:
(1/2): perl-DBD-MySQL-3.0007-2.el5.x86_64.rpm                                 | 148 kB     00:00
(2/2): mysql55-server-5.5.28-2.ius.el5.x86_64.rpm                             |  12 MB     00:03
-----------------------------------------------------------------------------------------------------
Total                                                                2.9 MB/s |  12 MB     00:04
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing     : perl-DBD-MySQL                                                                1/2
  Installing     : mysql55-server                                                                2/2

Installed:
  mysql55-server.x86_64 0:5.5.28-2.ius.el5

Dependency Installed:
  perl-DBD-MySQL.x86_64 0:3.0007-2.el5

Complete!

上手くいったようだ。結果として /usr/bin/以下にインストールされているようだ。

■MySQL Serverの起動

# /etc/rc.d/init.d/mysqld start
MySQL データベースを初期化中:  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:

/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h 127.0.0.1 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.

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

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

Please report any problems with the /usr/bin/mysqlbug script!

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

■MySQL Serverの自動起動設定

chkconfig mysqld on
chkconfig --list mysqld
mysqld   0:off   1:off   2:on    3:on    4:on    5:on    6:off

One Response to CentOS5.8にMySQL5.5をインストールする

  1. Pingback: Whoocus » Blog Archive » CentOS6.7へのMySQL5.6のインストール方法

コメントを残す

メールアドレスが公開されることはありません。 * が付いている欄は必須項目です