mysql错误Error(1133): Can’t find any matching row in the use

 执行插入用户语句没有问题，但是执行权限赋值的时候提示：1133 - Can't find any matching row in the user table;

 解决办法：插入新的用户成功时，需要刷新（flush privileges;）下mysql 权限列表。

当SQL线程停止 重启无效的时候，需要将1133错误跳过一次

stop slave；

SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; 　　# 跳过一个错误

start slave;

mysql官方解释：https://bugs.mysql.com/bug.php?id=55286

there is a problem with GRANT and the replication. The slave uses "skip_name_resolv" and the binlog_format is 'MIXED' on the master.
If you grant something to an user with an IP there is no problem. It fails with characters in host.