xtrabckup备份报错:Failed to connect to MySQL server: Can't connect to local MySQL server through socket '/data/mysql/mysql.sock' (2).

1.做软连接

[root@xxxxxx:/data/backup/log]# ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
[root@xxxxxxxxx:/data/backup/log]# ln -s /var/lib/mysql/mysql.sock /data/mysql/mysql.sock

 

2.mysql> show variables like '%slave_parallel_workers%';
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| slave_parallel_workers | 0     |
+------------------------+-------+
1 row in set (0.00 sec)

设置成0

posted on 2018-03-12 10:58  战神V祝福  阅读(265)  评论(0编辑  收藏  举报