Hackfix mysql replication
If replication is broken by a simple invalid query, i.e. grants change, etc. you can force-skip that query:
stop slave;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
start slave;
show slave status\G
If replication is broken by a simple invalid query, i.e. grants change, etc. you can force-skip that query:
stop slave;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
start slave;
show slave status\G