centos7执行mysql客户端命令出现此类错误:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
mysql.sock 一般不是在 /tmp/mysql.sock 就是在 /var/lib/mysql/mysql.sock 这里
没有的话就用ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
或者是ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock
彻底卸载mysql的方法:
查看是否安装:yum list install mysql*
rpm -qa | grep -i mysql
卸载安装包:
yum remove mysql mysql-server mysql-libs compat-mysql51
yum remove mysql-community-release
继续删除安装目录及配置文件等,可参考:https://blog.csdn.net/zhwyj1019/article/details/80274269
主主复制出现此错误:Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file
解决方式:stop slave;reset slave;start slave;(亲测成功)
主主复制出现冲突错误解决方案:stop slave;set global sql_slave_skip_counter=1;start slave;
主从复制跳过事件:在从服务器设置变量,set global sql_slave_skip_counter = N 正确的也能被跳过!!
或者:slave-skip-error=错误编号