以下是本人在linux环境中安装多个mysql服务笔记,工大家参考!1、按照常规安装。[root@ff_girl mysql5122]# chown -r root .[root@ff_girl my
以下是本人在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 .
示例配置文件
[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]#
，