linux 机器上有2个mysql server 一个端口是3305
一是 3306我准备分别用
/etc/init.d/mysql restart
service mysqld restart
来重启 端口是3305的 mysql server 问该如何做?(上面的2个命令该如何修改)
一是 3306我准备分别用
/etc/init.d/mysql restart
service mysqld restart
来重启 端口是3305的 mysql server 问该如何做?(上面的2个命令该如何修改)
是否如下
/etc/init.d/mysql restart -P3305
service mysqld restart -P3305
类似如下[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
安装疑似如下(源码安装)
scripts/mysql_install_db --basedir=/usr/local/mysql5122/ --datadir=/usr/local/mysql5122/data/ --user=mysql
Installing MySQL system tables...
OK
Filling help tables...
感觉
/etc/init.d/mysql restart -P3305
service mysqld restart -P3305 不见得会成功哦???
2 mysqlmulti --这个有点像/usr/bin/mysqlmulti上面的方法可能有问题的