※MySQLはすでにインストール済みの状態
# mkdir /var/lib/mysqld_multi
# mkdir /var/lib/mysqld_multi/mysql1
# mkdir /var/lib/mysqld_multi/mysql2
# chown -R mysql:mysql /var/lib/mysqld_multi
※必要な個所のみ記載
[mysqld_multi]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
log = /var/log/mysqld_multi.log
# インスタンス1の設定
[mysqld1]
port = 3306
datadir = /var/lib/mysqld_multi/mysql1
pid-file = /var/lib/mysqld_multi/mysql1/mysql.pid
socket = /var/lib/mysqld_multi/mysql1/mysql.sock
log-error = /var/lib/mysqld_multi/mysql1/error.log
general_log_file = /var/lib/mysqld_multi/mysql1/query.log
# インスタンス2の設定
[mysqld2]
port = 3307
datadir = /var/lib/mysqld_multi/mysql2
pid-file = /var/lib/mysqld_multi/mysql2/mysql.pid
socket = /var/lib/mysqld_multi/mysql2/mysql.sock
log-error = /var/lib/mysqld_multi/mysql2/error.log
general_log_file = /var/lib/mysqld_multi/mysql2/query.log
# mysql_install_db --datadir=/var/lib/mysqld_multi/mysql1 --user=mysql
# mysql_install_db --datadir=/var/lib/mysqld_multi/mysql2 --user=mysql
# mysqld_multi start
# mysqld_multi stop