/usr/local/mysql
这个时候默认的是使用3306端口
我们这里另建两个3307,3308
1,首先建两个目录
/usr/local/mysql/data_1/
/usr/local/mysql/data_2/
并把/usr/local/mysql/data/数据考入刚刚建好的两个目录
2在/usr/local/mysql下面建两个文件
文件名:mysql_start.sh
export PATH=/usr/local/mysql/bin:$PATH
CONF_FILE=/usr/local/mysql/my_multi.cnf
MYSQL_HOME=/usr/local/mysql
$MYSQL_HOME/bin/mysqld_multi --defaults-extra-file=$CONF_FILE start $1,$2
mysql_start.sh这个文件是用来运行mysql的
文件名:my_multi.cnf
[mysqld_multi]
mysqld = /usr/local/mysql/bin/mysqld_safe
mysqladmin = /usr/local/mysql/bin/mysqladmin
user = root
#实例1
[mysqld1]
socket = /tmp/mysql_3307.sock
#端口
port = 3307
#进程ID文件
pid-file = /usr/local/mysql/data_1/hostname.pid
#数据文件存储目录