下載安裝包

下載鏈接
https://dev.mysql.com/downloads/mysql/
選擇 Linux-Generic All

wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.18-linux-glibc2.12-x86_64.tar.xz

解壓移動(dòng)

tar -Jxf mysql-8.0.18-linux-glibc2.12-x86_64.tar.xz
mv mysql-8.0.18-linux-glibc2.12-x86_64 /opt/data/mysql

創(chuàng)建mysql實(shí)例用戶及文件

useradd mysql   // 創(chuàng)建用戶

mkdir -p /opt/data/mysql_8_{3306,3307}  // 創(chuàng)建文件

chown root.mysql -R /opt/data/mysql   // 修改mysql目錄的屬組及用戶

chown mysql.mysql -R /opt/data/   // 修改專用目錄的屬主及屬組

配置MySQL的配置文件/etc/my.cnf：

[mysqld_multi]
mysqld = /opt/data/mysql/bin/mysqld
mysqladmin = /opt/data/mysql/bin/mysqladmin
log = /mysqllog/mysql_multi.log


[mysqld1]
datadir = /opt/data/mysql_8_3306/data       //設(shè)置數(shù)據(jù)目錄
socket = /opt/data/mysql_8_3306/mysql.sock         //設(shè)置sock文件存放路徑
port = 3306                      //設(shè)置監(jiān)聽開放端口　
user = mysql                           //設(shè)置運(yùn)行用戶
performance_schema = off          //關(guān)閉監(jiān)控
innodb_buffer_pool_size = 32M         //設(shè)置innodb 緩存大小
bind_address = 0.0.0.0                  //設(shè)置監(jiān)聽IP地址
skip-name-resolve = 0                 //關(guān)閉DNS反向解析


[mysqld2]
datadir = /opt/data/mysql_8_3307/data
socket = /opt/data/mysql_8_3307/mysql.sock
port = 3307
user = mysql
performance_schema = off
innodb_buffer_pool_size = 32M
bind_address = 0.0.0.0
skip-name-resolve = 0

初始化各個(gè)實(shí)例

初始化完后會在日志中生成密碼，記得保存，一會要用。

/opt/data/mysql/bin/mysqld --initialize --user=mysql --basedir=/opt/data/mysql --datadir=/opt/data/mysql_8_3306/data
密碼： QKdoottea0#u

/opt/data/mysql/bin/mysqld --initialize --user=mysql --basedir=/opt/data/mysql --datadir=/opt/data/mysql_8_3307/data
密碼： %jDh<a>Ks9eI

開啟各實(shí)例的SSL連接

/opt/data/mysql/bin/mysql_ssl_rsa_setup --user=mysql --basedir=/opt/data/mysql --datadir=/opt/data/mysql_8_3306/data

/opt/data/mysql/bin/mysql_ssl_rsa_setup --user=mysql --basedir=/opt/data/mysql --datadir=/opt/data/mysql_8_3307/data

復(fù)制多實(shí)例腳本到服務(wù)管理目錄下

cp /opt/data/mysql/support-files/mysqld_multi.server /etc/init.d/mysqld_multi
chmod +x /etc/init.d/mysqld_multi

修改/etc/init.d/mysqld_multi配置為自己的路徑

basedir=/opt/data/mysql
bindir=/opt/data/mysql/bin

加入service服務(wù)管理

chkconfig –add mysqld_multi

查看多個(gè)實(shí)例狀態(tài)：mysqld_multi report

啟動(dòng)各個(gè)實(shí)例 ： mysqld_multi start

添加環(huán)境變量

在文件最后面添加內(nèi)容：sudo vim /etc/profile

## SETUP MYSQL’S PATH
export MYSQL_HOME=/opt/data/mysql
export PATH=${MYSQL_HOME}/bin:$PATH

登錄mysql

/opt/data/mysql/bin/mysql -S /opt/data/mysql_8_3306/mysql.sock -p'QKdoottea0#u'

/opt/data/mysql/bin/mysql -S /opt/data/mysql_8_3307/mysql.sock -p'%jDh<a>Ks9eI'

修改密碼

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';

使修改生效

flush privileges;