centos7_mysql5.7多实例安装配置

第一步：下载MySQL（阿里云）

[root@dba01 ~]# wget https://mirrors.aliyun.com/mysql/MySQL-5.7/mysql-5.7.36-linux-glibc2.12-x86_64.tar.gz

第二步：创建目录，并解压mysql

[root@dba01 ~]# mkdir -p /data/330{7,8,9}/data            # mysql数据目录
[root@dba01 ~]# mkdir -p /application/mysql               # mysql主体目录

第三部：解压mysql到对应目录

[root@dba01 ~]# tar -xf mysql-5.7.36-linux-glibc2.12-x86_64.tar.gz
[root@dba01 ~]# mv mysql-5.7.36-linux-glibc2.12-x86_64 /application/mysql

第四步：创建mysql用户

[root@dba01 ~]# useradd mysql -M -s /sbin/nologin         # 创建mysql用户

第五步：创建三个实例的配置文件

[root@dba01 ~]# cat > /data/3307/my.cnf <<EOF
[mysqld]
# mysql实例文件目录
basedir=/application/mysql
# mysql数据文件目录
datadir=/data/3307/data
# socket文件位置
socket=/data/3307/mysql.sock
# 日志存放目录
log_error=/data/3307/mysqld.log
# 指定端口号
port=3307
# 指定id
server_id=7
# 日志
log_bin=/data/3307/mysql-bin
EOF

cat > /data/3308/my.cnf <<EOF
[mysqld]
basedir=/application/mysql
datadir=/data/3308/data
socket=/data/3308/mysql.sock
log_error=/data/3308/mysqld.log
port=3308
server_id=8
log_bin=/data/3308/mysql-bin
EOF

cat > /data/3309/my.cnf <<EOF
[mysqld]
basedir=/application/mysql
datadir=/data/3309/data
socket=/data/3309/mysql.sock
log_error=/data/3309/mysqld.log
port=3309
server_id=9
log_bin=/data/3309/mysql-bin
EOF

第六步：初始化配置文件

[root@dba01 ~]# cd /application/mysql/bin
./mysqld --initialize-insecure --user=mysql --datadir=/data/3307/data --basedir=/application/mysql 
./mysqld --initialize-insecure --user=mysql --datadir=/data/3308/data --basedir=/application/mysql
./mysqld --initialize-insecure --user=mysql --datadir=/data/3309/data --basedir=/application/mysql

第七步：创建启动服务文件（就是创建快捷方式到桌面）

[root@dba01 ~]# cat > /etc/systemd/system/mysqld3307.service <<EOF
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/application/mysql/bin/mysqld --defaults-file=/data/3307/my.cnf
LimitNOFILE = 5000
EOF

cat > /etc/systemd/system/mysqld3308.service <<EOF
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/application/mysql/bin/mysqld --defaults-file=/data/3308/my.cnf
LimitNOFILE = 5000
EOF

cat > /etc/systemd/system/mysqld3309.service <<EOF
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/application/mysql/bin/mysqld --defaults-file=/data/3309/my.cnf
LimitNOFILE = 5000
EOF

第八步：授权

[root@dba01 ~]# chown -R mysql.mysql /data/*

第九步：启动

[root@dba01 ~]# systemctl start mysqld3307
[root@dba01 ~]# systemctl start mysqld3308
[root@dba01 ~]# systemctl start mysqld3309

第十步：查看服务状态

[root@dba01 ~]# netstat -lnp|grep mysql
tcp6       0      0 :::3307        :::*        LISTEN        45571/mysqld        
tcp6       0      0 :::3308        :::*        LISTEN        45706/mysqld        
tcp6       0      0 :::3309        :::*        LISTEN        45742/mysqld        
unix  2   [ ACC ]   STREAM   LISTENING   76825   45571/mysqld   /data/3307/mysql.sock
unix  2   [ ACC ]   STREAM   LISTENING   76024   45742/mysqld   /data/3309/mysql.sock
unix  2   [ ACC ]   STREAM   LISTENING   76909   45706/mysqld   /data/3308/mysql.sock

第十一步：登录测试

[root@dba01 ~]# mysql -S /data/3307/mysql.sock
mysql> 

第十二步：修改数据库密码

mysql> alter user 'root'@'localhost' identified by '密码';
Query OK, 0 rows affected (0.01 sec)

第十三步：授予远程登录权限

mysql> grant all privileges on *.* to root@'%' identified by '密码';
Query OK, 0 rows affected, 1 warning (0.01 sec)

第十四步：远程登录测试

[root@dba01 ~]# mysql -uroot -p123456 -h10.0.0.51 -P3307

使用远程登录工具SQLyog登录