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]#08012415:01:46mysqld_safe Logging to'/usr/local/mysql5122/data/localhost.localdomain.err'.
08012415:01:46mysqld_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 is1
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|
+--------------------+
3rows in set(0.00sec)
给MYSQLD_MULTI赋SHUTDOWN权限。mysql>grant shutdown on*.*to multi_admin@'localhost' identified by'123456';
Query OK,0rows affected(0.00sec)
mysql>flush privileges;
Query OK,0rows affected(0.00sec)
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.
示例配置文件[root@ff_girl mysql5122]#cat/etc/my5122.cnf
[mysqld_multi]
mysqld=/usr/local/mysql5122/bin/mysqld_safe
mysqladmin=/usr/local/mysql5122/bin/mysqladmin
user=multi_admin
password=123456
#The MySQL server
[mysqld1]
socket=/tmp/mysql1.sock
port=3307
pid-file=/usr/local/mysql5122/data1/david_yeung.pid1
datadir=/usr/local/mysql5122/data1
language=/usr/local/mysql5122/share/mysql/english
user=mysql
#The MySQL server
[mysqld2]
port=3308
socket=/tmp/mysql2.sock
pid-file=/usr/local/mysql5122/data2/david_yeung.pid2
datadir=/usr/local/mysql5122/data2
language=/usr/local/mysql5122/share/mysql/english
user=mysql
。。。
[isamchk]
key_buffer=8M
sort_buffer_size=8M
[myisamchk]
key_buffer=8M
sort_buffer_size=8M
[mysqlhotcopy]
interactive-timeout
[root@ff_girl mysql5122]#
启动两个MYSQL服务[root@ff_girl mysql5122]#/usr/local/mysql5122/bin/mysqld_multi--config-file=/etc/my5122.cnf start1-2
[root@ff_girl mysql5122]#netstat-an|grep3307
tcp000.0.0.0:33070.0.0.0:*LISTEN
[root@ff_girl mysql5122]#netstat-an|grep3308
tcp000.0.0.0:33080.0.0.0:*LISTEN
[root@ff_girl mysql5122]#/usr/local/mysql/bin/mysql-uroot-p-S/tmp/mysql1.sock
Enter password:
Welcome to the MySQL monitor.Commands end with;or\g.
Your MySQL connection id is1
Server version:5.1.22-rc-log MySQL Community Server(GPL)
Type'help;' or'\h' for help.Type'\c' to clear the buffer.
mysql>\q
Bye
[root@ff_girl mysql5122]#/usr/local/mysql/bin/mysql-uroot-p-S/tmp/mysql2.sock
Enter password:
Welcome to the MySQL monitor.Commands end with;or\g.
Your MySQL connection id is1
Server version:5.1.22-rc-log MySQL Community Server(GPL)
Type'help;' or'\h' for help.Type'\c' to clear the buffer.
mysql>\q
Bye
[root@ff_girl mysql5122]#
2、另外一种。[root@ff_girl mysql512]#chown-R root.
[root@ff_girl mysql512]#chown-R mysql data
[root@ff_girl mysql512]#chgrp-R mysql.
[root@ff_girl mysql512]#scripts/mysql_install_db--user=mysql--basedir=/usr/local/mysql512/--datadir=/usr/local/mysql512/data/
[root@ff_girl mysql512]#cp support-files/my-huge.cnf/etc/my512.cnf
并且修改如下部分。[client]
port=3308
socket=/tmp/mysql512.sock
#The MySQL server
[mysqld]
user=mysql
basedir=/usr/local/mysql512
datadir=/usr/local/mysql512/data
port=3308
socket=/tmp/mysql512.sock
[root@ff_girl mysql512]#/usr/local/mysql512/bin/mysqld_safe--defaults-file=/etc/my512.cnf&
[root@ff_girl mysql512]#/usr/local/mysql/bin/mysql-uroot-p-S/tmp/mysql512.sock
Enter password:
Welcome to the MySQL monitor.Commands end with;or\g.
Your MySQL connection id is1
Server version:5.1.22-rc-log MySQL Community Server(GPL)
Type'help;' or'\h' for help.Type'\c' to clear the buffer.
mysql>show databases;
+--------------------+
|Database|
+--------------------+
|information_schema|
|mysql|
|test|
+--------------------+
3rows in set(0.00sec)
mysql>\q
Bye
确定3308端口是否在运行。[root@ff_girl mysql512]#netstat-an|grep3308
tcp000.0.0.0:33080.0.0.0:*LISTEN
把脚本写到启动文件里：/usr/local/mysql512/bin/mysqld_safe--defaults-file=/etc/my512.cnf