show variables like 'character%';

vim /app/mysql-master/conf/my.cnf

[client]
# 設(shè)置客戶端的默認(rèn)字符集為 utf8
default-character-set = utf8

[mysqld]
# 設(shè)置服務(wù)器的排序規(guī)則為 utf8_general_ci
collation-server = utf8_general_ci

# 設(shè)置服務(wù)器的默認(rèn)字符集為 utf8
character-set-server = utf8

docker restart mysql-master

# \G 可以將橫向的結(jié)果集表格轉(zhuǎn)換成縱向展示。
# slave status的字段比較多，縱向展示比友好
show slave status \G;

# 查看防火墻狀態(tài)
systemctl status firewalld

# 暫時關(guān)閉防火墻
systemctl stop firewalld

# 永久關(guān)閉防火墻
systemctl disable firewalld

docker restart mysql-master

show master status;

stop slave;

-- 格式：
-- change master to master_host='宿主機ip',master_user='主數(shù)據(jù)庫配置的主從復(fù)制用戶名',master_password='主數(shù)據(jù)庫配置的主從復(fù)制用戶密碼',master_port=宿主機主數(shù)據(jù)庫端口,master_log_file='主數(shù)據(jù)庫主從同步狀態(tài)的文件名File',master_log_pos=主數(shù)據(jù)庫主從同步狀態(tài)的Position,master_connect_retry=連接失敗重試時間間隔（秒）;

change master to master_host='192.168.xxx.xxx',master_user='slave',master_password='123456',master_port=3307,master_log_file='mall-mysql-bin.000001',master_log_pos=769,master_connect_retry=30;

-- 配置完成后在進行啟動同步
start slave;

# \G 可以將橫向的結(jié)果集表格轉(zhuǎn)換成縱向展示。
# slave status的字段比較多，縱向展示比友好
show slave status \G;

use mysql;
select host,user,plugin from user;

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

ALTER USER 'slave'@'%' IDENTIFIED WITH mysql_native_password BY '123456';