mysql常用配置查询

赋予权限：

grant replication slave on *.* to 'root'@'%' identified by 'root'

grant all privileges on *.* to 'root'@'%' identified by 'root'

show variables like '%innodb_page_size%'

show variables like '%innodb_buffer%';

show variables like '%innodb_purge_threads%';

SHOW TABLE STATUS;

select * from information_schema.innodb_sys_tables;

show variables like '%innodb_undo%';

show variables like '%innodb_log%';

show variables like '%log_bin%';

show binary logs;

show master status;

show binlog events;

mysqlbinlog --start-datetime="2021-04-25 18:00:00" --stop- datetime="2021-07-26 00:00:00" mysqlbinlog.000008 | mysql -uroot -p1234

change master to 
master_host='106.75.60.175',
master_user='root',
master_password='1234',
master_log_file='mysql-bin.000011',
master_port=3306,
master_log_pos=450

重置 slave

stop slave；

reset slave (all);