mysql多实例配置

1、mysql安装参考：https://mp.csdn.net/postedit/49427733

2、创建   实例的数据文件目录：

cd /data/

mkdir   -p   {dbdata1,dbdata2}/data

3、copy   mysql软件到对应实例目录下

cd /data/

cp -R mysql/ dbdata1/

cp -R mysql/ dbdata2/

4、编辑配置文件my.cnf

cd /data/dbdata1/
vi my.cnf

  4、2       3306端口服务配置

[client]

#password   = [your_password]
port        = 3306
socket      = /data/dbdata1/mysql.sock
default-character-set=utf8
# *** Application-specific options follow here ***

[mysqld]

port =3306

basedir = /data/dbdata1/mysql
datadir=/data/dbdata1/data
socket=/data/dbdata1/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
skip-federated
init_connect='SET collation_connection = utf8_general_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_general_ci
bind-address=0.0.0.0
lower_case_table_names=1
event_scheduler=1
server-id=1
[mysqld_safe]
log-error=/data/dbdata1/mysqld.log
pid-file=/data/dbdata1/mysqld.pid

    4.2    3307服务配置文件

[client]
#password   = [your_password]
port        = 3307
socket      = /data/dbdata2/mysql.sock
default-character-set=utf8
# *** Application-specific options follow here ***


[mysqld]
basedir = /data/dbdata2/mysql
datadir=/data/dbdata2/data
socket=/data/dbdata2/mysql.sock
port =3307
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
skip-federated
init_connect='SET collation_connection = utf8_general_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_general_ci
bind-address=0.0.0.0
lower_case_table_names=1
event_scheduler=1
server-id=2
[mysqld_safe]
log-error=/data/dbdata2/mysqld.log

pid-file=/data/dbdata2/mysqld.pid

5、初始化两个实例的库

./data/dbdata1/mysql/scripts/mysql_install_db --user=mysql  --basedir=/data/dbdata1/mysql --datadir=/data/dbdata1/data

./data/dbdata2/mysql/scripts/mysql_install_db --user=mysql  --basedir=/data/dbdata2/mysql --datadir=/data/dbdata2/data

6、启动两个实例

/data/dbdata1/mysql/bin/mysqld_safe --defaults-file=/data/dbdata1/my.cnf 2>&1 >/dev/null &
/data/dbdata2/mysql/bin/mysqld_safe --defaults-file=/data/dbdata2/my.cnf 2>&1 >/dev/null &

7、停止实例

mysqladmin -u root -p passwd -S /data/dbdata1/mysql.sock shutdown

登录MySQL

mysql -S /data/dbdata1/mysql.sock

设置密码

mysqladmin -u root -S /data/3306/mysql.sock password 'password'