MySQLをrpmでインストールする
ローカル開発環境で色々なバージョンのmysqlをインストールすることになったのでメモ。
■今入っているmysqlを確認する。
# rpm -qa|grep mysql
■既に入っているmysqlを削除する
# yum remove mysql-*
■インストールしたいバージョンのmysqlを探す
◇Download MySQL Community Server
◇MySQL Community Server (Archived Versions)
■作業フォルダにインストールしたいバージョンをダウンロードしてくる
# wget http://dev.mysql.com/get/Downloads/MySQL-5.1/MySQL-5.1.73-1.glibc23.x86_64.rpm-bundle.tar
■解凍する
# tar xvfp MySQL-5.1.73-1.glibc23.x86_64.rpm-bundle.tar MySQL-server-5.1.73-1.glibc23.x86_64.rpm MySQL-shared-compat-5.1.73-1.glibc23.x86_64.rpm MySQL-debuginfo-5.1.73-1.glibc23.x86_64.rpm MySQL-embedded-5.1.73-1.glibc23.x86_64.rpm MySQL-devel-5.1.73-1.glibc23.x86_64.rpm MySQL-client-5.1.73-1.glibc23.x86_64.rpm MySQL-test-5.1.73-1.glibc23.x86_64.rpm MySQL-shared-5.1.73-1.glibc23.x86_64.rpm
■yum localinstallでまとめてインストールする
※バージョンのところとかは適宜変更。
# yum localinstall MySQL-{client,devel,server,shared-compat}-5.1.73-1.glibc23.x86_64.rpm
Loaded plugins: fastestmirror, versionlock
Setting up Local Package Process
Examining MySQL-client-5.1.73-1.glibc23.x86_64.rpm: MySQL-client-5.1.73-1.glibc23.x86_64
Marking MySQL-client-5.1.73-1.glibc23.x86_64.rpm to be installed
Loading mirror speeds from cached hostfile
* base: ftp.riken.jp
* epel: ftp.jaist.ac.jp
* extras: ftp.riken.jp
* updates: ftp.riken.jp
Examining MySQL-devel-5.1.73-1.glibc23.x86_64.rpm: MySQL-devel-5.1.73-1.glibc23.x86_64
Marking MySQL-devel-5.1.73-1.glibc23.x86_64.rpm to be installed
Examining MySQL-server-5.1.73-1.glibc23.x86_64.rpm: MySQL-server-5.1.73-1.glibc23.x86_64
Marking MySQL-server-5.1.73-1.glibc23.x86_64.rpm to be installed
Examining MySQL-shared-compat-5.1.73-1.glibc23.x86_64.rpm: MySQL-shared-compat-5.1.73-1.glibc23.x86_64
Marking MySQL-shared-compat-5.1.73-1.glibc23.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package MySQL-client.x86_64 0:5.1.73-1.glibc23 will be installed
---> Package MySQL-devel.x86_64 0:5.1.73-1.glibc23 will be installed
---> Package MySQL-server.x86_64 0:5.1.73-1.glibc23 will be installed
---> Package MySQL-shared-compat.x86_64 0:5.1.73-1.glibc23 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
=============================================================================================================================================================
Package Arch Version Repository Size
=============================================================================================================================================================
Installing:
MySQL-client x86_64 5.1.73-1.glibc23 /MySQL-client-5.1.73-1.glibc23.x86_64 16 M
MySQL-devel x86_64 5.1.73-1.glibc23 /MySQL-devel-5.1.73-1.glibc23.x86_64 30 M
MySQL-server x86_64 5.1.73-1.glibc23 /MySQL-server-5.1.73-1.glibc23.x86_64 38 M
MySQL-shared-compat x86_64 5.1.73-1.glibc23 /MySQL-shared-compat-5.1.73-1.glibc23.x86_64 7.0 M
Transaction Summary
=============================================================================================================================================================
Install 4 Package(s)
Total size: 91 M
Installed size: 91 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.1.73-1.glibc23.x86_64 1/4
Installing : MySQL-server-5.1.73-1.glibc23.x86_64 2/4
Installing : MySQL-devel-5.1.73-1.glibc23.x86_64 3/4
Installing : MySQL-shared-compat-5.1.73-1.glibc23.x86_64 4/4
Verifying : MySQL-shared-compat-5.1.73-1.glibc23.x86_64 1/4
Verifying : MySQL-devel-5.1.73-1.glibc23.x86_64 2/4
Verifying : MySQL-server-5.1.73-1.glibc23.x86_64 3/4
Verifying : MySQL-client-5.1.73-1.glibc23.x86_64 4/4
Installed:
MySQL-client.x86_64 0:5.1.73-1.glibc23 MySQL-devel.x86_64 0:5.1.73-1.glibc23 MySQL-server.x86_64 0:5.1.73-1.glibc23
MySQL-shared-compat.x86_64 0:5.1.73-1.glibc23
Complete!
■既存の残骸が無いように消しておく
# cd /var/lib/mysql/ # pwd /var/lib/mysql # rm -rf ./*
■「mysql_install_db」コマンド実行
# mysql_install_db --datadir=/var/lib/mysql --user=mysql WARNING: The host 'vagrant-centos65.vagrantup.com' 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: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h vagrant-centos65.vagrantup.com 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/bin/mysqld_safe & You can test the MySQL daemon with mysql-test-run.pl cd //mysql-test ; perl mysql-test-run.pl Please report any problems with the /usr/bin/mysqlbug script!
■起動
# service mysql start
■パスワード設定
# /usr/bin/mysqladmin -u root password 'パスワード'
■「mysql_secure_installation」コマンドを実行
# /usr/bin/mysql_secure_installation
■mysqlに接続してざっくり設定する。（ローカル用）
mysql> select user, host from mysql.user; mysql> grant all privileges on *.* to root@'192.168.%' identified by 'パスワード'; mysql> flush privileges;
■文字コードとか設定する
ゴニョゴニョ。
バージョンによる。
■設定変えたので再起動
# service mysql restart
■サービスに登録する
■参考URL
http://www.torutk.com/projects/swe/wiki/CentOS_6%E3%81%A7MySQL_56%E3%82%92%E3%82%A4%E3%83%B3%E3%82%B9%E3%83%88%E3%83%BC%E3%83%AB
http://blog.r-unit.co.jp/archives/964
http://d.hatena.ne.jp/tetsuyai/20110418/1303133792
http://qiita.com/840_/items/06f32fecbe57c3fdf5ec
http://www.infoscoop.org/blogjp/2012/04/18/mysql5-5/
Fatal error: Can’t open and lock privilege tables: Table ‘mysql.host’ doesn’t exist
http://d.hatena.ne.jp/tomoyamkung/20081225/1230165109
http://dev.mysql.com/doc/refman/5.1/ja/mysql-install-db.html