shuaihhx的小屋

＊ 配置了主从同步，主为服务器，从为本地，但不知道为什么，过一段时间后（暂未发现规律），同步就会断掉，显示如下：

mysql> show slave status \G
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
							 ......
							 ......
                   Last_Error: Error 'Can't find any matching row in the user table' on query. Default database: ''. Query: 'GRANT CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'root'@'%' WITH GRANT OPTION'

需要重新change master配置，但过一段时间就又挂掉了。