1、更新my.cnf配置文件

1.cat /etc/mysql/my.cnf[mysqld_multi]mysqld=/usr/local/mysql/bin/mysqld_safemysqladmin=/usr/local/mysql/bin/mysqladminLog=/usr/local/mysql/logs/multi.log[mysqld1]datadir=/usr/local/mysql/data1socket=/usr/local/mysql/run/mysql.sock3307pid-file=/usr/local/mysql/run/mysql1.pidport=3307[mysqld2]datadir=/usr/local/mysql/data2socket=/usr/local/mysql/run/mysql.sock3308pid-file=/usr/local/mysql/run/mysql2.pidport=3308[mysqld3]datadir=/usr/local/mysql/data3socket=/usr/local/mysql/run/mysql.sock3309pid-file=/usr/local/mysql/run/mysql3.pidport=3309

2、初始化mysqld（记录每个实例产生的随机明码）

bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data1 --user=mysql --initializebin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data2 --user=mysql --initializebin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data3 --user=mysql --initialize

3、启动多实例

mysqld_multi reportmysqld_multi start 1mysqld_multi start 2mysqld_multi start 3

4、别离连贯每个实例，而后批改明码

mysql -u root -S /usr/local/mysql/run/mysql.sock3307 -pmysql -u root -S /usr/local/mysql/run/mysql.sock3308 -pmysql -u root -S /usr/local/mysql/run/mysql.sock3309 -p

5、增加开机自启动mysqld_multi

cp support-files/mysqld_multi.server /etc/init.d/mysqld_multichkconfig --add mysqld_multichkconfig --list | grep mysql