2012年5月9日水曜日

MySQL5.1 install on CentOS 5 by yum


※this text from livedoor blog 2009/10/26
最近(2012/5)はMySQL5.5が入る筈


MySQL5.1をyumでインストールする

最新版のmysqlがremiに置いてあるので
remiレポジトリを追加する、remiレポジトリを追加するにはepelも要るので一緒に入れておく

プロセッサを調べる
$ uname -a
Linux ip-10-251-163-176 2.6.21.7-2.fc8xen-ec2-v1.0 #1 SMP Tue Sep 1 10:25:30 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux

epel-release-X-X.noarch.rpmを探す
http://download.fedora.redhat.com/pub/epel/5/i386/
epel-release-5-4.noarch.rpmが見つかったとする

i386の場合
$ wget http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-4.noarch.rpm
$ wget http://rpms.famillecollet.com/el5.i386/remi-release-5-8.el5.remi.noarch.rpm
$ sudo rpm -Uvh epel-release-5-4.noarch.rpm
$ sudo rpm -Uvh remi-release-5-8.el5.remi.noarch.rpm

x86_64の場合
$ wget http://download.fedora.redhat.com/pub/epel/5/x86_64/epel-release-5-4.noarch.rpm
$ wget http://rpms.famillecollet.com/el5.x86_64/remi-release-5-8.el5.remi.noarch.rpm
$ sudo rpm -Uvh epel-release-5-4.noarch.rpm
$ sudo rpm -Uvh remi-release-5-8.el5.remi.noarch.rpm

remiレポジトリを有効にする
$ sudo emacs /etc/yum.repos.d/remi.repo
[remi]
enabled=1

yumでインストールする
$ sudo yum install mysql-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * addons: mirror.averse.net
 * base: mirror.averse.net
 * epel: ftp.kddilabs.jp
 * extras: mirror.averse.net
 * remi: rpms.famillecollet.com
 * updates: mirror.averse.net
remi                                                                                          | 2.3 kB     00:00  
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql-server.i386 0:5.1.40-1.el5.remi set to be updated
--> Processing Dependency: mysql = 5.1.40-1.el5.remi for package: mysql-server
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16) for package: mysql-server
--> Processing Dependency: libmysqlclient_r.so.16(libmysqlclient_16) for package: mysql-server
--> Processing Dependency: perl-DBI for package: mysql-server
--> Processing Dependency: perl-DBD-MySQL for package: mysql-server
--> Processing Dependency: perl(DBI) for package: mysql-server
--> Processing Dependency: libmysqlclient_r.so.16 for package: mysql-server
--> Processing Dependency: libmysqlclient.so.16 for package: mysql-server
--> Running transaction check
---> Package mysql.i386 0:5.1.40-1.el5.remi set to be updated
---> Package mysql-libs.i386 0:5.1.40-1.el5.remi set to be updated
---> Package perl-DBD-MySQL.i386 0:3.0007-2.el5 set to be updated
--> Processing Dependency: libmysqlclient.so.15 for package: perl-DBD-MySQL
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15) for package: perl-DBD-MySQL
---> Package perl-DBI.i386 0:1.52-2.el5 set to be updated
--> Running transaction check
---> Package mysqlclient15.i386 0:5.0.67-1.el5.remi set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

=====================================================================================================================
 Package                        Arch                 Version                              Repository            Size
=====================================================================================================================
Installing:
 mysql-server                   i386                 5.1.40-1.el5.remi                    remi                  11 M
Installing for dependencies:
 mysql                          i386                 5.1.40-1.el5.remi                    remi                 3.9 M
 mysql-libs                     i386                 5.1.40-1.el5.remi                    remi                 2.1 M
 mysqlclient15                  i386                 5.0.67-1.el5.remi                    remi                 1.3 M
 perl-DBD-MySQL                 i386                 3.0007-2.el5                         base                 148 k
 perl-DBI                       i386                 1.52-2.el5                           base                 600 k

Transaction Summary
=====================================================================================================================
Install      6 Package(s)      
Update       0 Package(s)      
Remove       0 Package(s)      

Total download size: 19 M
Is this ok [y/N]: y
インストールしたいバージョンであることを確認する

ベンチとmysql-develも入れておく
$ sudo yum install mysql-bench
$ sudo yum install mysql-devel

MySQLを起動する
$ sudo /etc/init.d/mysqld start

パスワードを設定する
$ /usr/bin/mysql -uroot
mysql> SET PASSWORD FOR root@localhost=PASSWORD('********');
mysql> SET PASSWORD FOR user@localhost=PASSWORD('********');