MySQL 5.6版本二进制包多实例（版本1）

MySQL安装

（1）解压
tar -zxvf mysql-5.6.46-linux-glibc2.12-x86_64.tar.gz -C /usr/local/

（2）创建软链接
ln -sv /usr/local/mysql-5.6.46-linux-glibc2.12-x86_64 /usr/local/mysql

（3）创建mysql 用户
useradd -M -s /sbin/nologin mysql

（4）创建目录结构和授权
mkdir /opt/data/{3306,3307}/ -p
chown -R mysql.mysql /opt/data

（5）添加环境变量
echo 'export PATH=$PATH:/usr/local/mysql/bin' >>  /etc/profile  
export PATH=$PATH:/usr/local/mysql/bin

（6）初始化数据库

/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/opt/data/3306/data
/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/opt/data/3307/data

（7）修改配置
cd /opt/data/3306/data 
nano my.cnf

 [client]    
port        = 3306     
socket      = /opt/data/3306/data/mysql3306.sock

[mysqld]    
port        = 3306     
socket      =  /opt/data/3306/data/mysql3306.sock     
datadir     =  /opt/data/3306/data
max_connections=1000
character-set-server=utf8
innodb_file_per_table=1
lower_case_table_names=1 
log_error=/opt/data/3306/data/mysql3306.err 

cd /opt/data/3307/data 
nano my.cnf

 [client]    
port        = 3307     
socket      = /opt/data/3307/data/mysql3307.sock

[mysqld]    
port        = 3307     
socket      =  /opt/data/3307/data/mysql3307.sock     
datadir     =  /opt/data/3307/data
max_connections=1000
character-set-server=utf8
innodb_file_per_table=1
lower_case_table_names=1 
log_error=/opt/data/3307/data/mysql3307.err 

（8）启动多实例

/usr/local/mysql/bin/mysqld_safe --defaults-file=/opt/data/3306/data/my.cnf &
/usr/local/mysql/bin/mysqld_safe --defaults-file=/opt/data/3307/data/my.cnf &

（9）修改密码
/usr/local/mysql/bin/mysqladmin -u root password "123456" -S /opt/data/3306/data/mysql3306.sock 
/usr/local/mysql/bin/mysqladmin -u root password "123456" -S /opt/data/3307/data/mysql3307.sock

查看进程
netstat -tulnp

（10）登陆数据库
/usr/local/mysql/bin/mysql -uroot -p -S /opt/data/3306/data/mysql3306.sock 
/usr/local/mysql/bin/mysql -uroot -p -S /opt/data/3307/data/mysql3307.sock 

https://blog.51cto.com/jinlong/2059076
https://blog.csdn.net/weixin_34001430/article/details/89869565
https://www.jianshu.com/p/3bf7fe15dd45