Mysql8.0多实例安装(二进制)Centos7.4

下载二制包

wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.22-linux-glibc2.12-x86_64.tar.xz

安装依赖

yum install libaio

添加用户

useradd mysql 

解压安装

tar -xJf mysql-8.0.22-linux-glibc2.12-x86_64.tar.xz -C /usr/local/

ln -s  /usr/local/mysql-8.0.22-linux-glibc2.12-x86_64  /usr/local/mysql

chown -R mysql:mysql /usr/local/mysql-*

编写配置文件(/etc/my.cnf)

[mysqld_multi]
mysqld=/usr/local/mysql/bin/mysqld_safe
mysqladmin=/usr/local/mysql/bin/mysqladmin
log=/usr/local/mysql/mysqld_multi.log

[mysqld]
user=mysql
basedir=/usr/local/mysql
character_set_server=utf8mb4
collation_server=utf8mb4_general_ci

log_error=error.log

[mysqld3306]
port=3306
datadir=/data/mysqld_3306
socket=mysqld.sock

[mysqld3307]
port=3307
datadir=/data/mysqld_3307
socket=mysqld.sock

多初始化实例

cd /usr/local/mysql

mkdir -p /data/mysqld_3306  &&  chown -R mysql:mysql /data/mysqld_3306

bin/mysqld  --user=mysql --datadir=/data/mysqld_3306  --initialize-insecure     #不设置密码

mkdir -p /data/mysqld_3307  &&  chown -R mysql:mysql /data/mysqld_3307

bin/mysqld  --user=mysql --datadir=/data/mysqld_3307  --initialize-insecure   #不设置密码

环境变量(临时有效)

export MYSQL_HOME=/usr/local/mysql

export PATH=$PATH:$MYSQL_HOME/bin

启动实例

mysqld_multi report 

mysqld_multi start 3306

mysqld_multi start 3307

测试初始密码

mysql -S /data/mysqld_3306/mysqld.sock -e "set password='123456';flush privileges;"

mysql -S /data/mysqld_3307/mysqld.sock -e "set password='123456';flush privileges;"

添加远程账号

mysql -S /data/mysqld_3306/mysqld.sock -p'123456' -e "create user root identified with mysql_native_password by '123456' ;grant all on *.* to root;flush privileges;"

mysql -S /data/mysqld_3306/mysqld.sock -p'123456' -e "create user root identified with mysql_native_password by '123456' ;grant all on *.* to root;flush privileges;"

#  ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';   #修改密码加密规则