Mysql同步报错

蓝天上的青鸟

Mysql数据库同步出现的错误

#mysql -u root -p

mysql> show slave status\G;

 Error 'Duplicate entry '%-smarteye' for key 'PRIMARY'' on query. Default database: 'smarteye'. Query: 'insert into mysql.user ( host, user, password, select_priv, insert_priv,                      update_priv, delete_priv,  create_priv, drop_priv, reload_priv, shutdown_priv,               process_priv,  file_priv, grant_priv, references_priv, index_priv, alter_priv, show_db_priv, super_priv, create_tmp_table_priv, lock_tables_priv,                   execute_priv, repl_slave_priv, repl_client_priv, create_view_priv, show_view_priv,create_routine_priv, alter_routine_priv, create_user_priv, event_priv, trigger_priv ) values ( '%', 'smarteye', PASSWORD('sm**xacc&123'), 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N' )'

1 row in set (0.00 sec)

解决办法

mysql> delete from mysql.user where host="%" and user="smarteye";

=================================================================

知识点滴积累  QQ：1359962567