操作系统:ubuntu 16.04
两台服务器ip分别为:
192.168.0.105
192.168.0.106
虚拟ip为:192.168.0.250
一. 离线安装mysql8.0.18
1. 下载mysql安装包
百度网盘
提取码:22th
2. 安装mysql
依次执行下面11条命令
sudo dpkg -i mysql-community-client-core_8.0.18-1ubuntu16.04_amd64.deb
sudo dpkg -i mysql-common_8.0.18-1ubuntu16.04_amd64.deb
sudo dpkg -i mysql-community-client_8.0.18-1ubuntu16.04_amd64.deb
sudo dpkg -i libmysqlclient21_8.0.18-1ubuntu16.04_amd64.deb
sudo dpkg -i libmysqlclient-dev_8.0.18-1ubuntu16.04_amd64.deb
sudo dpkg -i libaio1_0.3.110-2_amd64.deb
sudo dpkg -i libmecab2_0.996-1.2ubuntu1_amd64.deb
sudo dpkg -i mysql-client_8.0.18-1ubuntu16.04_amd64.deb
sudo dpkg -i mysql-community-server-core_8.0.18-1ubuntu16.04_amd64.deb
sudo dpkg -i mysql-community-server_8.0.18-1ubuntu16.04_amd64.deb
sudo dpkg -i mysql-server_8.0.18-1ubuntu16.04_amd64.deb
注:执行第10条命令时,会提示设置密码,如下图,选择5.x版本的加密方式:
安装完成后启动mysql
service mysql start
登陆验证安装成功
二. mysql配置互为主从
1.创建同步用户
使用mysql数据库
use mysql;
然后分别为另一主机创建一个链接用户,该帐户必须授予REPLICATION SLAVE权限,因为mysql8在授权语句中不能出现IDENTIFIED BY ‘password’; 因此创建用户和授予权限需要分开执行:
在105上执行创建用户并赋权:
CREATE USER 'replicate'@'192.168.0.106' IDENTIFIED WITH 'mysql_native_password' BY 'root';
GRANT REPLICATION SLAVE ON *.* TO 'replicate'@'192.168.0.106';
在106上执行&#x