- 论坛徽章:
- 2
|
mysql 运行正常的情况下 在master 库上新增用户权限 ,发现slave 都挂了
创建用户及赋权命令如下:
mysql> create user test@'%';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> update user set password=password('zsh') where user='test';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> GRANT ALL PRIVILEGES ON *.* TO test@'%' IDENTIFIED BY PASSWORD '*84CC991F2B08632D6B01FC13FDBBA3FED084008F';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
check binlog 发现如下错误:
# at 6759
#140519 10:43:52 server id 55 end_log_pos 6850 CRC32 0xa24fb9eb Query thread_id=45622 exec_time=0 error_code=0
SET TIMESTAMP=1400467432/*!*/;
SET @@session.pseudo_thread_id=45622/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=0/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C utf8 *//*!*/;
SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=33/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
create user test@'%'
/*!*/;
# at 6850
#140519 10:45:17 server id 55 end_log_pos 6907 CRC32 0xdcc008ed
# Incident: LOST_EVENTS
RELOAD DATABASE; # Shall generate syntax error
# at 6907
#140519 10:45:17 server id 55 end_log_pos 6954 CRC32 0x7d7a5c47 Rotate to mysql-bin.000012 pos: 4
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
请教大家 create user 怎么会导致binlog 异常 (replication 也断掉了)……
哪位遇到过这样的情况?多提高贵意见和建议啊
|
|