MySQL 8.0 同版本多实例

初始化配置

# 初始化数据目录
$ /opt/mysql/bin/mysqld --initialize-insecure --datadir=/data/mysql3303 --basedir=/opt/mysql/ --user=mysql

# 制作启动文件
$ cp /etc/systemd/system/mysqld.service /etc/systemd/system/mysqld3303.service
$ cat /etc/systemd/system/mysqld3303.service 
[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=/opt/mysql/bin/mysqld --defaults-file=/etc/my3303.cnf
LimitNOFILE = 5000

# 制作配置文件
$ cat /etc/my3303.cnf 
[mysqld]
server-id=3
port=3303
basedir=/opt/mysql
datadir=/data/mysql3303
innodb_file_per_table=1
default_storage_engine=InnoDB
log-bin=/var/log/mysql3303/mysql-bin
socket=/var/log/mysql3303/mysql3303.sock
user=mysql
symbolic-links=0
log-error=/var/log/mysql3303/mysql3303err.log
pid-file=/var/log/mysql3303/mysql3303.pid
log_timestamps=system
skip-name-resolve=ON
#lower_case_table_names=1      #表名存储在磁盘是小写的，但是比较的时候是不区分大小写

secure_file_priv=''           #MySQL导出查询结果到本地安全参数
#slow-log
slow_query_log=1
long_query_time=5
log_queries_not_using_indexes=on
slow_query_log_file=/var/log/mysql3303/mysql_slow.log

mysqlx=OFF #mysqlx参数，建议关闭，或者指定其它端口，默认是33060

#GTID
gtid_mode = ON
enforce_gtid_consistency = ON

#Clone Plugin
plugin-load-add=mysql_clone.so

[client]
port=3303
socket=/var/log/mysql3303/mysql3303.sock

修改数据库登录密码

# 修改登录密码
$ /opt/mysql/bin/mysqld_safe --defaults-file=/etc/my3303.cnf --user=mysql --skip-grant-tables &
$ mysql -uroot -S /var/log/mysql3303/mysql3303.sock -p

 mysql> flush privileges;
 mysql> alter user root@'localhost' identified by '4321';
# 注意修改密码完成后也需要再次刷新数据到权限表中，让密码权限认证生效

mysql> flush privileges;

启动数据库实例

$ systemctl daemon-load 
$ systemctl start mysqld3303.service
$ netstat -ntlp  grep -E '33063303'
tcp        0      0 0.0.0.0:5700            0.0.0.0:*               LISTEN      13306/docker-proxy  
tcp6       0      0 :::33060                :::*                    LISTEN      17467/mysqld        
tcp6       0      0 :::3303                 :::*                    LISTEN      23270/mysqld        
tcp6       0      0 :::3306                 :::*                    LISTEN      17467/mysqld