mysql 主从关系杂记

mysqld --install mysqlmaster --defaults-file=“D:\ChromeCoreDownloads\mysql-5.7.28-winx64\my.ini”

CREATE USER  'test'@'localhost'  IDENTIFIED BY  '123456';
GRANT privileges ON  databasename.tablename  TO  ‘username’@‘host’;

GRANT ALL PRIVILEGES ON *.* TO  'test'@'localhost' ;
FLUSH PRIVILEGES;

grant replication slave on *.* to 'test'@'192.168.0.101' identified by '123456';

change master to master_host='192.168.0.101',master_user='test',master_password='123456',master_log_file='mysql-bin.000002',master_log_pos=1203;

再去查看主库上的binlog日志
show binlog events in 'master-bin.000002';  #全部查看
https://www.cnblogs.com/zyxnhr/p/11130000.html

通过CHANGE　MASTER 命令将 MASTER_LOG_FILE和MASTER_LOG_POS重新指定一下。

set global sql_slave_skip_counter=1; 
https://blog.51cto.com/wujianwei/1934135

MyCat简单使用与配置
https://www.jianshu.com/p/26513f428ecf

CREATE USER  'Mycat'@'192.168.0.101'  IDENTIFIED BY  '123456';
GRANT privileges ON  jzfx.tablename  TO  ‘username’@‘host’;
--可以使用下面这句 赋予所有权限
GRANT ALL PRIVILEGES ON *.* TO  'Mycat'@'%' ;
--最后刷新权限
FLUSH PRIVILEGES;

grant all privileges on *.* to 'skip-grants user'@'skip-grants host' identified by ".";