XtraBackup出现 Can't connect to local MySQL server through socket '/tmp/mysql.sock'

Xtrabackup做备份时遇到下面错误信息MySQL server: Can't connect to local MySQL server through socket '/tmp/mysql.so‘（2）

[root@MySQL-DB ~]# innobackupex --defaults-file=/usr/my.cnf --user=root --password=password  /mnt/resource/mysql_backup

160322 22:28:43 innobackupex: Starting the backup operation

IMPORTANT: Please check that the backup run completes successfully.

           At the end of a successful backup run innobackupex

           prints "completed OK!".

160322 22:28:43  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root'  (using password: YES).

Failed to connect to MySQL server as DBD::mysql module is not installed at - line 1327.

160322 22:28:43 Connecting to MySQL server host: localhost, user: root, password: set, port: 0, socket: (null)

Failed to connect to MySQL server: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).

出现这种情况是因为我修改了my.cnf中参数datadir，但是没有修改socket参数（参数为空），所以出现这个错误。另外我估计更换MySQL数据目录后,如果没有正确配置也会出现这个错误. 我们首先找到对应的mysql.sock文件位置，然后修改my.cnf中的参数scoket值，重启MySQL服务即可解决

[root@MySQL-DB mysql_backup]# find / -name "mysql.sock"

/var/lib/mysql/mysql.sock

另外，其实我这篇文章ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)里介绍的建立软连接也可解决这个问题。

另外，在网上也有种偏方解决这个问题，即指定--host=127.0.0.1也可避免这个错误，我测试确实也能解决问题。不过这个是个治标不治本的方法.

innobackupex --defaults-file=/usr/my.cnf --user=root --password=password --host=127.0.0.1 /mnt/resource/mysql_backup

时间： 2024-11-02 14:13:05

XtraBackup出现 Can't connect to local MySQL server through socket '/tmp/mysql.sock'的相关文章

解决Can't connect to local MySQL server through socket '/tmp/mysql.sock'错误

风信网(ithov.com)原创文章:刚安装完mysql,进行运行测试,报Can't connect to local MySQL server through socket '/tmp/mysql.sock'错误, [root@localhost mysql]# /usr/local/mysql/bin/mysqld_safe 131206 22:42:51 mysqld_safe Logging to '/var/log/mysqld.log'. 131206 22:42:51 mysqld

Can t connect to local MySQL server through socket /tmp/mysql.sock

不能通过'/tmp/mysql.sock'连到服务器,而php标准配置正是用过'/tmp/mysql.sock',但是一些mysql安装方法将 mysql.sock放在/var/lib/mysql.sock或者其他的什么地方,你可以通过修改/etc/my.conf文件来修正它首先是mysqld启动不了, 我通过vim /etc/my.cnf,修改了[mysqld]选项下面的socket的值 socket=/var/lib/mysql/mysql.sock ok,mysqld可以启动了接下来,

Ruby on Rails 3 Can&#39;t connect to local MySQL server through socket &#39;/tmp/mysql.sock&#39; on linux

Ruby on Rails 3 Can't connect to local MySQL server through socket '/tmp/mysql.sock' on linux 解决办法: up vote1down voteaccepted First, to find your socket file: mysqladmin variables | grep socket For me, this gives: | socket | /tmp/mysql.sock | 2 Then

ERROR 2002 (HY000): Cant connect to local MySQL server through socket的解决方法

连接MySQL提示ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)的解决方法 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) 原文:http://www.aiezu.com/db/mysql_cant_connect_thro

启动MYSQL提示：Can’t connect to MySQL through socket ‘/tmp/mysql.sock’

启动MYSQL是出现以下错误: [root@www ~]# /usr/local/webserver/mysql/bin/mysqladmin -u root -p 12345678 Enter password: /usr/local/webserver/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket

MYSQL错误解决：ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 据说这个问题的原因很多,当然,我自己这个问题我是清楚的,就是mysql.sock的位置所致,一个是PHP要求的,一个是MYSQLD定义的,一个是MY.CONF指定的...SO.... 暂时不能统一的话,用软链接LN -S命令解决吧.. 方案5 摘要:解决不能通过mysql .so

MYSQL错误解决：ERROR 2002 (HY000): Can&#39;t connect to local MySQL server through socket &#39;/var/lib/mysql/mysql.sock&#39; (2)

Can’t connect to local MySQL server through socket

mysql,Mysqldump,Mysqladmin,php连接mysql服务常会提示下面错误: 1 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 这是由于修改mysql服务的了socket文件mysql.sock位置,而导致无法通过mysql socket文件连接到mysql服务引起的,具体解决办法如下:1.查看mysql服务的sock

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

从供应商手中接手一个云平台(Windwos Azure)上的MySQL数据库,登录数据库时遇到错误: $mysql -uroot -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 检查配置文件/etc/my.cnf发现供应商修改了mysql数据库的数据存储目录,另外mysql.sock文件位置也变更为了/