Shulou(Shulou.com)06/01 Report--

Mysql 5.7 encountered an error while stopping the replication process from the library because the replication information was recorded in the table.

Error prompt:

ERROR 1794 (HY000): Slave is not configured or failed to initialize properly. You must at least set-- server-id to enable either a master or a slave. Additional error messages can be found in the MySQL error log.

Solution:

Use mysql

Drop table slave_master_info

Drop table slave_relay_log_info

Drop table slave_worker_info

Drop table innodb_index_stats

Drop table innodb_table_stats

Source / usr/coolpad/mysql/share/mysql_system_tables.sql

Restart the database

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.