mysql8 一主一从 +mycat2 读写分离

一单台安装mysql

mkdir /usr/local/mysql && cd /usr/local/mysql/

wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.29-1.el7.x86_64.rpm-bundle.tar

tar -xvf mysql-8.0.29-1.el7.x86_64.rpm-bundle.tar

安装

rpm -ivh mysql-community-common-8.0.29-1.el7.x86_64.rpm mysql-community-libs-8.0.29-1.el7.x86_64.rpm mysql-community-libs-compat-8.0.29-1.el7.x86_64.rpm mysql-community-client-8.0.29-1.el7.x86_64.rpm mysql-community-server-8.0.29-1.el7.x86_64.rpm --nodeps --force

初始化

mysqld --initialize;chown mysql:mysql /var/lib/mysql -R;systemctl start mysqld.service;systemctl enable mysqld;

查看默认密码

cat /var/log/mysqld.log | grep password

登录修改密码

mysql -uroot -p

修改密码

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

远程登录授权

用户查看</