mysql_multi

#多实例启动
#创建dir后,chown -R mysql.mysql dir_name

# mysql_install_db -user=mysql --datadir=/data/path/local_mysql_data/
#创建创建实例方式
#mysqld_multi --defaults-extra-file=`pwd`/mysql.cnf start 3308
#mysqladmin -uroot -S ./local_mysql/mysqld3308.sock password 12345678
#访问方法
#mysql -uroot -p12345678 -S /data/path/local_mysql/mysqld3308.sock

[mysqld_multi]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
user = root
password = 123456

[mysqld3308]
port = 3308
datadir = /data/path/local_mysql_data
socket = /data/path/local_mysql/mysqld3308.sock
pid-file = /data/path/local_mysql/mysql3308.pid
log-error = /data/path/local_mysql/local_mysql_error.log
character-set-server = utf8mb4
lower_case_table_names=1