1,先按MySQL5.7安装好后
mkdir dbdata_3307
chown mysql:mysql -R dbdata_3307
2,./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/dbdata_3307 -- 1个实例
3,./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/dbdata_3308 --另一个实例
4,启动: mysql -uroot -p -S /tmp/mysql3307.sock
mysql -uroot -p -S /tmp/mysql3308.sock
修改My.cnf
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
[mysqld_multi]
mysqld=/usr/local/mysql/bin/mysqld_safe
mysqladmin =/usr/local/mysql/bin/mysqladmin
user = admin
password = 123
[mysqld3307]
socket = /tmp/mysql3307.sock
port = 3307
pid-file = /usr/local/mysql/dbdata_3307/mysql3307.pid
datadir = /usr/local/mysql/dbdata_3307
basedir = /usr/local/mysql
user = mysql
server-id=3307
[mysqld3308]
socket = /tmp/mysql3308.sock
port = 3308
pid-file =/usr/local/mysql/dbdata_3308/mysql3308.pid
datadir = /usr/local/mysql/dbdata_3308
basedir = /usr/local/mysql
user = mysql
server-id=3308
启动: mysqld_multi start 3307
查看状态:mysqld_multi report 3307