创建一个新的Mysql实例

 

1.拷贝一份mysql

  mv mysql  mysq3310

2.修改my.conf

[mysqld]
basedir = /usr/local/mysql3312
datadir = /data/mysql/3312
port = 3312
server_id = 271712
socket = /tmp/mysql_3312.sock

 

3.创建data目录

mkdir  /data/mysql/3312

 

4.初始化

scripts/mysql_install_db --basedir=/usr/local/mysql3312/ --datadir=/data/mysql/3312 --defaults-file=my.cnf --user=mysql

 

5. 准备启动

 cd /etc/init.d/

 

 cp mysqld mysql3312

 

vi mysql3312

 

basedir=/usr/local/mysql3312
datadir=/data/mysql/3312

 

6.启动

 

/etc/init.d/mysql3312 start