mysql5.7.23多实例安装

参考1：https://www.cnblogs.com/xuchenliang/p/6843990.html
参考2：https://blog.csdn.net/weixin_30480651/article/details/98952934
解压安装包
tar -zxvf mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.20-linux-glibc2.12-x86_64 /usr/local/mysql
2.4.关闭iptables
临时关闭：service iptables stop
永久关闭：chkconfig iptables off
centos 7
查看防火墙状态
systemctl status firewalld.service
关闭
systemctl stop firewalld.service
2.5.关闭selinux
vi /etc/sysconfig/selinux
将SELINUX修改为DISABLED，即SELINUX=DISABLED
2.6.创建mysql用户
groupadd -g 27 mysql
useradd -u 27 -g mysql mysql
id mysql
uid=501(mysql) gid=501(mysql) groups=501(mysql)
2.7.创建相关目录
mkdir -p /data/mysql/ {mysql_3306,mysql_3307}
mkdir /data/mysql/mysql_3306/ {data,log,tmp}
mkdir /data/mysql/mysql_3307/ {data,log,tmp}
2.8.更改目录权限
chown -R mysql:mysql /data/mysql/
chown -R mysql:mysql /usr/local/mysql/
2.9. 添加环境变量
echo ‘export PATH=$PATH:/usr/local/mysql/bin’ >> /etc/profile
source /etc/profile
2.10.复制my.cnf文件到etc目录
cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
2.11.修改my.cnf（在一个文件中修改即可）
[client]
port=3306
socket=/tmp/mysql.sock

[mysqld_multi]
mysqld = /usr/local/mysql /bin/mysqld_safe
mysqladmin = /usr/local/mysql /bin/mysqladmin
log = /data/mysql/mysqld_multi.log

[mysqld]
user=mysql
basedir = /usr/local/mysql
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[mysqld3306]
mysqld=mysqld
mysqladmin=mysqladmin
datadir=/data/mysql/mysql_3306/data
port=3306
server_id=3306
socket=/tmp/mysql_3306.sock
log-output=file
slow_query_log = 1
long_query_time = 1
slow_query_log_file = /data/mysql/mysql_3306/log/slow.log
log-error = /data/mysql/mysql_3306/log/error.log
binlog_format = mixed
log-bin = /data/mysql/mysql_3306/log/mysql3306_bin

[mysqld3307]
mysqld=mysqld
mysqladmin=mysqladmin
datadir=/data/mysql/mysql_3307/data
port=3307
server_id=3307
socket=/tmp/mysql_3307.sock
log-output=file
slow_query_log = 1
long_query_time = 1
slow_query_log_file = /data/mysql/mysql_3307/log/slow.log
log-error = /data/mysql/mysql_3307/log/error.log
binlog_format = mixed
log-bin = /data/mysql/mysql_3307/log/mysql3307_bin
2.12. 初始化数据库
[root@MySQL ~]# /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/mysql_3306/data
[root@MySQL ~]# /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/mysql_3307/data

复制多实例脚本到服务管理目录下 [ /etc/init.d/ ]
[root@MySQL ~]# cp /usr/local/mysql/support-files/mysqld_multi.server /etc/init.d/mysqld_multi

添加脚本执行权限
[root@MySQL ~]# chmod +x /etc/init.d/mysqld_multi

添加进service服务管理
[root@MySQL ~]# chkconfig --add mysqld_multi

[root@MySQL ~]# /etc/init.d/mysqld_multi report
Reporting MySQL servers
MySQL server from group: mysqld1 is not running
MySQL server from group: mysqld2 is not running
MySQL server from group: mysqld3 is not running
MySQL server from group: mysqld4 is not running
启动多实例
[root@MySQL ~]# /etc/init.d/mysqld_multi start

[root@MySQL ~]# netstat -lntp | grep mysqld

登录
mysql -S /tmp/mysql_3306.sock -p
mysql -S /tmp/mysql_3307.sock -p

mysql> SET PASSWORD = PASSWORD(‘nroot’);
或者
mysql>set password for root@‘localhost’=password(‘nroot’);
或者
mysql> alter user ‘root’@‘localhost’ identified by ‘nroot’;–CREATE USER ‘username’@‘host’ IDENTIFIED BY ‘password’;
mysql> grant all privileges on . to ‘root’@’%’ identified by ‘nroot’ with grant option;;
mysql> flush privileges;

2.17.新建用户及授权
一般新建数据库都需要新增一个用户，用于程序连接，这类用户只需要insert、update、delete、select权限。
新增一个用户，并授权如下：
grant select,delete,update,insert on . to admin@’%’ identified by ‘123456’;
flush privileges
报错解

决
[root@localhost /]# /usr/local/mysql/bin/mysqld_multi start 1
WARNING: my_print_defaults command not found.
Please make sure you have this command available and
in your path. The command is available from the latest
MySQL distribution.
ABORT: Can’t find command ‘my_print_defaults’.
This command is available from the latest MySQL
distribution. Please make sure you have the command
解决：
添加
export PATH=/usr/local/mysql/bin:$PATH
source /etc/profile