Mysql的各种报错解决方法

启动 mysql 报错：

2021-10-20T09:56:25.530839Z 0 [ERROR] [MY-000000] [WSREP] P: It may not be safe to bootstrap the cluster from this node. It was not the last one to leave the cluster and may not contain all the updates. To force cluster bootstrap with this node, edit the grastate.dat file manually and set safe_to_bootstrap to 1

vi /var/lib/mysql/grastate.dat

      

主从报错：

1062报错时步骤：

stop slave;

set global sql_slave_skip_counter=1;

start slave;

show slave status\G;

GTID不一致时步骤：

主查看：show global variables like 'gtid_%';

stop slave;

SET GLOBAL gtid_slave_pos='0-1-770';

start slave;

show slave status\G;

因为账号原因不同步时：