mysql8.0多实例安装

1. 下载mysql二进制安装包

mysql8.0.16下载连接

2. 解压mysql二进制安装包

将mysql-8.0.16-linux-glibc2.12-x86_64.tar.xz二进制压缩包上传至/usr/local下并且解压

tar -xvf mysql-8.0.16-linux-glibc2.12-x86_64.tar.xz
mv  mysql-8.0.16-linux-glibc2.12-x86_64   mysql

3. 创建mysql用户和用户组

useradd mysql
groupadd mysql
usermod -G mysql mysql
chown mysql:mysql mysql

4. 编辑my.cnf文件

vim /etc/my.cnf ,添加如下内容

[mysqld]
server-id=1
bind-address=0.0.0.0
port=3306
user=mysql
basedir=/usr/local/mysql
datadir=/data/mysql
socket=/tmp/mysql.sock
log-error=/data/mysql/mysql.err
pid-file=/data/mysql/mysql.pid
lower_case_table_names=1   //设置忽略大小写
#character config
character_set_server=utf8
#symbolic-links=0
plugin-load=validate_password.so    //这个需要添加
#skip-grant-tables


#启动多实例
[mysqld_multi]
mysqld     = /usr/local/mysql/bin/mysqld_safe
mysqladmin = /usr/local/mysql/bin/mysqladmin
log=/usr/local/mysql/mysqld_multi.log

[mysqld1]
socket     = /usr/local/mysql/data1/mysql.sock1
port       = 3307
pid-file   = /usr/local/mysql/data1/mysql1.pid
datadir    = /usr/local/mysql/data1
log-error  = /usr/local/mysql/data1/mysql1.err

[mysqld2]
socket     = /usr/local/mysql/data2/mysql.sock2
port       = 3308
pid-file   = /usr/local/mysql/data2/mysql2.pid
datadir    = /usr/local/mysql/data2
log-error  = /usr/local/mysql/data2/mysql2.err

[mysqld3]
socket     = /usr/local/mysql/data3/mysql.sock3
port       = 3309
pid-file   = /usr/local/mysql/data3/mysql3.pid
datadir    = /usr/local/mysql/data3
log-error  = /usr/local/mysql/data3/mysql3.err

[mysqld4]
socket     = /usr/local/mysql/data4/mysql.sock4
port       = 3310
pid-file   = /usr/local/mysql/data4/mysql4.pid
datadir    = /usr/local/mysql/data4
log-error  = /usr/local/mysql/data4/mysql4.err

[mysqld5]
socket     = /usr/local/mysql/data5/mysql.sock5
port       = 3311
pid-file   = /usr/local/mysql/data5/mysql5.pid
datadir    = /usr/local/mysql/data5
log-error  = /usr/local/mysql/data5/mysql5.err

然后执行chmod 644 my.cnf

5. 初始化mysql实例

创建mysql.err保存日志，
cd /usr/local/mysql
touch mysql.err
chmod 666 mysql.err
这里初始化五个mysql实例，五个实例的临时登录密码会输出到上面创建的mysql.err文件中
mysqld --initialize --lower_case_table_names=1 --datadir=/usr/local/mysql/data1
mysqld --initialize --lower_case_table_names=1 --datadir=/usr/local/mysql/data2
mysqld --initialize --lower_case_table_names=1 --datadir=/usr/local/mysql/data3
mysqld --initialize --lower_case_table_names=1 --datadir=/usr/local/mysql/data4
mysqld --initialize --lower_case_table_names=1 --datadir=/usr/local/mysql/data5

cat mysql.err查看各实例的临时登录密码

6. 启动mysql实例

启动1，2，3，4，5这个5个实例
mysqld_multi start 1-5
使用ps -ef|grep mysqld查看mysql进程，如下图表示说明多实例启动成功

7. 登录mysql实例

执行mysql -u root -p -S /usr/local/mysql/data1/mysql.sock1然后输入密码

初次登录后要马上执行如下命令修改密码

alter user 'root'@'localhost' identified with mysql_native_password BY 'Mysql214325*';

此时，在本机可以使用mysql数据库了，如果还想远程登录数据库，还要执行如下命令操作

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

此时就可以用客户端远程登录mysql数据库了

其他实例依此类推登录：

mysql -u root -p -S  /usr/local/mysql/data2/mysql.sock2
mysql -u root -p -S  /usr/local/mysql/data3/mysql.sock3
mysql -u root -p -S  /usr/local/mysql/data4/mysql.sock4
mysql -u root -p -S  /usr/local/mysql/data5/mysql.sock5

关闭mysql实例

执行此命令后输入密码就可关闭数据库实例了
mysqladmin -u root -p -S  /usr/local/mysql/data1/mysql.sock1 shutdown

如下所示实例1已经被关闭了

其他实例关闭都是这样操作，当然为了方便关闭数据库实例，可以使用脚本来关闭，脚本内容如下

#!/bin/bash
for ((i=1;i<=5;i++))
   do
           mysqladmin -u root -pMysql214325* -S /usr/local/mysql/data$i/mysql.sock$i shutdown > /dev/null
           if [ $? -eq 0 ]
                then echo "mysqld$i实例关闭成功"
              else echo "mysqld$i实例关闭失败！！！"
           fi
   done