mysql单实例多数据库_MySQL单台服务器跑多个实例子详解

[client]

# 默认 使用/tmp/mysql.sock1

socket = /tmp/mysql.sock1

[mysqld1]

socket = /tmp/mysql.sock1

port = 3306

pid-file = /var/data/data1/data1.pid

datadir = /var/data/data1

user = mysql

[mysqld2]

#mysqld = /usr/bin/mysqld_safe

#mysqladmin = /usr/bin/mysqladmin

socket = /tmp/mysql.sock2

port = 3307

pid-file = /var/data/data2/data2.pid

datadir = /var/data/data2

user = mysql

[mysqld3]

#mysqld = /usr/bin/mysqld_safe

#mysqladmin = /usr/bin/mysqladmin

socket = /tmp/mysql.sock3

port = 3308

pid-file = /var/data/data3/data3.pid

datadir = /var/data/data3

user = mysql