mysql8多实例启动

只在192.168.1.104机器上部署，本来已经创建了一个数据库，参照 https://www.jianshu.com/p/ba9f9ce5d1a9

1. cd /usr/local/mysql ,分别创建 3307/data 、3308/data目录，再分别复制my.cnf到3307、3308目录下
   以下只操作3307,3308同理：

cp /ect/my.cnf  /usr/local/mysql/3307

修改如下：

[client]
port=3307
socket=/usr/local/mysql/3307/mysql.sock
[mysqld]
port=3307
user=mysql
socket=/usr/local/mysql/3307/mysql.sock
basedir=/usr/local/mysql/3307
datadir=/usr/local/mysql/3307/data
log-error=/usr/local/mysql/3307/error.log
pid-file = /usr/local/mysql/3307/mysql.pid
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
lower_case_table_names = 1
default_authentication_plugin=mysql_native_password
server-id=3307
log-bin=mysql3307-bin

改权限：

chown -R mysql.mysql /usr/local/3307 /usr/local/3308

chmod -R 755 /usr/local/3307 /usr/local/3308

安装实例：

./usr/local/mysql/bin/mysqld_safe  --defaults-file=../3307/my.cnf --user=mysql &

查看密码：

cat /usr/local/mysql/3307/error.log

完毕后输入密码进入数据库

mysql -uroot -S ../3307/mysql.sock -p

修改密码

alter user 'root'@'localhost' identified with mysql_native_password by '密码'; 

修改访问限制以及刷新权限

use mysql;
update user set host ='%' where user = 'root'
flush privileges;
exit;

开放端口命令：

firewall-cmd  --add-port=3307/tcp --permanent

firewall-cmd  --add-port=3308/tcp --permanent

firewall-cmd --reload

最后查看进程

ps -ef |grep mysql

如下所示，即完成

[root@localhost mysql]# ps -ef |grep mysql;
root      9513  7503  0 3月21 pts/3   00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --defaults-file=../3307/my.cnf --user=mysql
mysql     9747  9513  0 3月21 pts/3   00:00:14 /usr/local/mysql/bin/mysqld --defaults-file=../3307/my.cnf --basedir=/usr/local/mysql/3307 --datadir=/usr/local/mysql/3307/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/usr/local/mysql/3307/error.log --pid-file=/usr/local/mysql/3307/mysql.pid --socket=/usr/local/mysql/3307/mysql.sock --port=3307
root      9986  7503  0 3月21 pts/3   00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --defaults-file=../3308/my.cnf --user=mysql
mysql    10221  9986  0 3月21 pts/3   00:00:15 /usr/local/mysql/bin/mysqld --defaults-file=../3308/my.cnf --basedir=/usr/local/mysql/3308 --datadir=/usr/local/mysql/3308/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/usr/local/mysql/3308/error.log --pid-file=/usr/local/mysql/3308/mysql.pid --socket=/usr/local/mysql/3308/mysql.sock --port=3308
root     11291  7503  0 3月21 pts/3   00:00:00 mysql -uroot -S ../3307/mysql.sock -p
root     14354  9878  0 00:24 pts/4    00:00:00 grep --color=auto mysq
root     20686     1  0 3月21 ?       00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysl/data --pid-file=/usr/local/mysql/mysql.pid
mysql    20938 20686  0 3月21 ?       00:02:07 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/usr/local/mysql/error.log --pid-file=/usr/local/mysql/mysql.pid --socket=/usr/local/mysql/mysql.sock --port=3306

使用navicat能登录上。

关闭一个mysql实例

mysqladmin -uroot -p shutdown -S /usr/local/mysql/3307/mysql.sock

另外一种multi方式： https://www.jianshu.com/p/a545c2d95194