在Linux下安装多个MySQL

1、按照常规安装。

[root@ff_girl mysql5122]# chown -R root .
[root@ff_girl mysql5122]# chown -R mysql data
[root@ff_girl mysql5122]# chgrp -R mysql .
[root@ff_girl mysql5122]# cp support-files/my-small.cnf /etc/my5122.cnf
[root@ff_girl mysql5122]# scripts/mysql_install_db --basedir=/usr/local/mysql5122/ --datadir=/usr/local/mysql5122/data/ --user=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
。。。

首次启动MYSQL

[root@ff_girl mysql5122]# bin/mysqld_safe --defaults-file=/etc/my5122.cnf &
[1] 13700
[root@ff_girl mysql5122]# 080124 15:01:46 mysqld_safe Logging to '/usr/local/mysql5122/data/localhost.localdomain.err'.
080124 15:01:46 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql5122/data

[root@ff_girl mysql5122]# bin/mysql -uroot -p -S/tmp/mysql5122.sock
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.22-rc MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+--------------------+
| Database　　　　　 |
+--------------------+
| information_schema |
| mysql　　　　　　　|
| test　　　　　　　 |
+--------------------+
3 rows in set (0.00 sec)

给MYSQLD_MULTI赋SHUTDOWN权限。

mysql> grant shutdown on *.* to multi_admin@'localhost' identified by '123456';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye

停掉MYSQL服务。

[root@ff_girl ~]# /usr/local/mysql5122/bin/mysqladmin -uroot -p -S/tmp/mysql5122.sock shutdown
Enter password:
[root@ff_girl ~]#

拷贝元数据。

[root@ff_girl mysql5122]# cp data data2
[root@ff_girl mysql5122]# mv data data1
[root@ff_girl mysql5122]# chown -R mysql data2
[root@ff_girl mysql5122]# chgrp -R mysql .