mkdir /var/lib/mysql_new
mysql_install_db --datadir=/var/lib/mysql_new --user=mysql
vi /etc/my.cnf 添加
[mysqld_multi]
mysqld=/usr/bin/mysqld_safe
mysqladmin=/usr/bin/mysqladmin
log=/var/log/mysqld_multi.log
user = multi_admin
password = multipass
[mysqld1]
datadir=/var/lib/mysql_new
socket=/var/lib/mysql_new/mysql.sock
port=4000
pid-file=/var/lib/mysql_new/mysql.pid
user=mysql
多實例啟動
mysqld_multi start 1關閉MySQL多實例mysqld_multi stop 1查看MySQL端口啟動狀態(tài)netstat -ntlp | grep mysqld
查看MySQL實例進程ps -ef | grep mysql
通過port連接
mysql -u root -h 127.0.0.1 -P 4000 通過sock
mysql -u root -S /var/lib/mysql_new/mysql.sock -p
faq
my.cnf-[mysqld_multi]設置的user和password是用來關閉數(shù)據庫實例的，根據配置中的用戶名和密碼授權該用戶shutdown權限
mysql -S /var/lib/mysql_new/mysql.sock
mysql> grant shutdown on *.* to multi_admin@'localhost' identified by 'multipass';