mysql多实例配置

1、在mysql安装目录下增加一个文件目录：data3307

2、给该目录权限设为mysql.mysql， 755

3、创建数据库并初始化

 /usr/local/mysql5.6/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql5.6  --datadir=/usr/local/mysql5.6/data3307/

4、vim /etc/my.cnf

增加：

[mysqld_multi]
mysqld=/usr/local/mysql5.6/bin/mysql_safe

[mysqld2]
port=3307
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
basedir=/usr/local/mysql5.6
datadir=/data/mysql5.6/data3307