mysql主从配置常用命令

授权远程用户权限(需要把my.cnf中的bind-address=127.0.0.1注释)
grant all privileges on *.* to username@'%' identified by 'password';
grant all privileges on *.* to username@'%' identified by 'password';


主从
show master status;
change master to Master_Log_File='mysql-bin.011558',Master_Log_Pos=605505007;
set global sql_slave_skip_counter =10000;start slave;


show slave status\G
stop slave;
start slave;