mysql-centos_multi

环境

禁用SELINUX

vim /etc/selinux/config

将selinux状态修改为disable

安装包获取

wgethttps://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz

配置

资源目录

# 解压
tar -zxvf mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz
# 重命名
mv mysql-5.7.19-linux-glibc2.12-x86_64 mysql
# 目录迁移
mv mysql /usr/local

环境变量

vim /etc/profile

编辑配置，将mysql可执行文件添加到环境变量中，即在/etc/profile末尾插入如下代码

export MYSQL_HOME=/usr/local/mysql
export PATH=${MYSQL_HOME}/bin:$PATH

并进行加载

source /etc/profile

用户设置

# 创建mysql用户
sudo useradd mysql -r -s /sbin/nologin
# 创建交互目录
sudo mkdir -p /usr/local/mysql/mysql_files
# 创建数据目录
sudo mkdir /data/mysql_data330{6..9}
# 授权
sudo chown root.mysql -R /usr/local/mysql
sudo chown mysql.mysql -R /usr/local/mysql/mysql_files /data/mysql_data330{6..9}

数据库配置

# mysql提供的多实例服务
[mysqld_multu]
mysqld=/usr/local/mysql/bin/mysqld
mysqladmin=/usr/local/mysql/bin/mysqladmin
log=/tmp/mysql_multi.log

[mysqld1]
datadir=/data/mysql_data3306
socket=/tmp/mysql3306.sock
port=3306
user=mysql
performance_schema=off
innodb_buffer_pool_size=32M
bind_address=0.0.0.0
skip-name-resolve=0

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

[mysqld3]
datadir=/data/mysql_data3308
socket=/tmp/mysql3308.sock
port=3308
user=mysql
performance_schema=off
innodb_buffer_pool_size=32M
bind_address=0.0.0.0
skip-name-resolve=0

[mysqld4]
datadir=/data/mysql_data3309
socket=/tmp/mysql3309.sock
port=3309
user=mysql
performance_schema=off
innodb_buffer_pool_size=32M
bind_address=0.0.0.0
skip-name-resolve=0

安装

初始化

# 3306
sudo /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql_data3306
# 3307
sudo /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql_data3307
# 3308
sudo /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql_data3308
# 3309
sudo /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql_data3309

该命令会打印初始化密码，请记住，后续修改密码需要先登陆。

开启连接

# 3306
sudo /usr/local/mysql/bin/mysqld_ssl_rsa_setup --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql_data3306
# 3307
sudo /usr/local/mysql/bin/mysqld_ssl_rsa_setup --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql_data3307
# 3308
sudo /usr/local/mysql/bin/mysqld_ssl_rsa_setup --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql_data3308
# 3309
sudo /usr/local/mysql/bin/mysqld_ssl_rsa_setup --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql_data3309

管理设置

# 管理脚本
sudo cp /usr/local/mysql/support-files/mysqld_multi.server /etc/init.d/mysqld_multi
# 添加管理
sudo chkconfig -add mysqld_multi

服务启动

# 状态监测
mysqld_multi report
# 服务启动
sudo mysqld_multi start

连接

连接数据库

sudo mysql -S /tmp/mysql3306.sock -p

sock地址配置文件中指定了，需要的密码是在前面提到的需要记录的密码。

修改密码

set password=password('godme');

登录授权

grant all privileges on *.* to root@'%' identified by 'godme';

刷库生效

flush privileges;