说明：linux采用centos8
mysql 主从复制配置
1.安装mysql
tar -zxvf mysql-8.0.34-linux-glibc2.28-x86_64.tar.gz
cd mysql-8.0.34-linux-glibc2.28-x86_64/
mkdir /var/lib/mysql
cp -R * /var/lib/mysql
groupadd mysql
useradd -g mysql mysql
cd /var/lib/mysql/
mkdir data
chown -R mysql.mysql /var/lib/mysql
在环境变量中加入 /etc/profile
export PATH=$PATH:/var/lib/mysql/bin
mysqld --user=mysql --basedir=/var/lib/mysql --datadir=/var/lib/mysql/data --initialize
编辑my.cnf文件
[mysqld]
port=3306
basedir=/var/lib/mysql
datadir=/var/lib/mysql/data
character-set-server=UTF8MB4
1.cp -a ./support-files/mysql.server /etc/init.d/mysql
2. chmod +x /etc/init.d/mysql
3. chkconfig --add mysql
4.service mysql start
5.登录mysql:mysql -uroot -p
修改root用户密码：alter user 'root'@'localhost' identified with mysql_native_password by 'cnhqd@123';
flush privileges;
允许远程登录：update user set host='%' where user='root';
flush privileges;
主：创建复制用户
create user 'chenglf'@'%' identified by 'cnhqd@123';
grant replication slave on *.* to 'chenglf'@'%';
grant replication SLAVE, replication client ON *.* TO 'chenglf'@'%';
flush privileges;
从服务器登录后执行：CHANGE MASTER TO MASTER_HOST='192.168.247.133', MASTER_USER='chenglf', MASTER_PASSWORD='cnhqd@123', MASTER_PORT=3306;