WEB开发网
开发学院数据库MySQL Linux安装多个MySQL 阅读

Linux安装多个MySQL

 2008-09-06 11:09:46 来源:WEB开发网   
核心提示: 给MYSQLD_MULTI赋SHUTDOWN权限,mysql> grant shutdown on *.* to multi_admin@'localhost' identified by '123456';Query OK, 0 rows affec

给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

上一页  1 2 3 4  下一页

Tags:Linux 多个

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接