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
