Hi
之前我也遇到這問題, 後來改了參數前後順序就可以了.
date=$(date "+%Y%m%d-%H:%M")
start() {
start5 ; start5_2
}
start5() {
/usr/local/mysql/bin/mysqld_safe --user=root &
echo "$date start mysql5 127.0.0.1 ..." >> /root/mysql.log
sleep 5;
}
start5_2() {
/usr/local/mysql/bin/mysqld_safe --defaults-extra-file=/usr/local/mysql/my5_2.cnf --user=root --pid-file=/usr/local/mysql/var/mysql52.pid --log-error=/usr/local/mysql/var/mysql52.err &
echo "$date start mysql5-2 172.18.185.140 ..." >> /root/mysql.log
sleep 5;
}
PS : my5_2.cnf 視情況修改
例 :
bind-address = 172.18.185.140
socket = /tmp/mysql5_2.sock
innodb_data_file_path = ibdata1_2:10M:autoextend