XtraBackup出现 Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

最新推荐文章于 2025-02-15 22:49:08 发布

weixin_33763244

最新推荐文章于 2025-02-15 22:49:08 发布

阅读量120

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/liang545621/p/10056828.html

本文提供了两种解决MySQL连接问题的方法：一是通过创建软链接，二是指定主机地址为127.0.0.1。适用于遇到MySQL连接错误的开发者。

解决办法1.建立一个软连接

ln -s /dat/data/mysql/mysql.sock /var/run/mysqld/mysqld.sock

解决办法2：
指定--host=127.0.0.1

转载于:https://www.cnblogs.com/liang545621/p/10056828.html

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

weixin_33763244

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

failed to connect to mysql_Xtrabackup备份报错Failed to connect to MySQL server

weixin_28733651的博客

02-01

1217

Xtrabackup备份报错/backup> innobackupex --defaults-file=/etc/my.cnf --user=root --password='xxxxx' /backup/20170803170421 18:15:39 innobackupex: Starting the backup operationIMPORTANT: Please check tha...

Xtrabackup备份报错Failed to connect to MySQL server

cuantangnie3915的博客

08-03

1607

Xtrabackup备份报错 /backup> innobackupex --defaults-file=/etc/my.cnf --user=root --password='xxxxx' /backup/201708...

参与评论您还未登录，请先登录后发表或查看评论

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

weixin_33672109的博客

03-22

440

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=passwor...

解决ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.soc...

weixin_30292745的博客

09-21

269

systemctl restart mariadb 数据库服务没有启动转载于:https://www.cnblogs.com/zcdhhh/p/11562035.html

xtrabckup备份报错：Failed to connect to MySQL server: Can't connect to local MySQL server through socket ...

weixin_30332705的博客

03-12

445

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 ...

250516 09:58:23 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=3306' as 'root' (using password: YES). Failed to connect to MySQL server: DBI connect(';mysql_read_default_group=xtrabackup;port=3306','root',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at - line 1315. 250516 09:58:23 Connecting to MySQL server host: localhost, user: root, password: set, port: 3306, socket: not set Failed to connect to MySQL server: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2).

05-17

当遇到 `ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'` 或 `/var/lib/mysql/mysql.sock` 的错误时，通常表明客户端无法通过 Unix 套接字文件与本地运行...

250707 19:39:42 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' (using password: NO). Failed to connect to MySQL server: DBI connect(';mysql_read_default_group=xtrabackup','',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at - line 1314. 250707 19:39:42 Connecting to MySQL server host: localhost, user: not set, password: not set, port: not set, socket: not set Failed to connect to MySQL server: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2).

07-08

connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/usr/local/mysql/tmp/mysql.sock' (2) 以及另一个引用中提到的： innobackupex: Connecting to MySQL ...

/var/lib/mysql/grastate.dat 没有那个文件

最新发布

09-11

我们正在解决一个关于MySQL中/var/lib/mysql/grastate.dat文件不存在的问题。根据引用[1]，这个文件可能与PXC（Percona XtraDB Cluster）节点加入集群时避免SST（State Snapshot Transfer）有关，而且在节点首次启动...

Mysql连接的过程中出现Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock

Pruett的博客

10-26

4304

突然登录数据库的时候,出现了如下错误:Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock 1.造成的可能原因上午在网上查了一下关于Ubuntu下如何解决MySQL数据库的乱码问题,要找到my.cnf文件,在里面的[client] 和[mysqld]这两个命令下面输入 default

【MySQL安装】—报错“Can‘t connect to local MySQL server through socket ‘varlibmysqlmysql.sock‘”

egekm_sefg的博客

02-15

717

一定要root用户下执行命令，atwqf用户是没有权限，执行"systemctl restart mysqld"命令重启mysql服务会报错。执行 "sudo cat /var/log/mysqld.log"命令，查看mysql运行日志，看错误原因。执行 “mysql -uroot -p” 命令，进入MySQL数据库。systemctl restart mysqld #重启mysql服务。/var/lib/mysql路径下缺少mysql.sock文件。

innobackupex: Error: Failed to connect to MySQL server as DBD

lwei_998的专栏

10-22

1万+

新环境上测试percona-xtrabackup-2.2.5-Linux-x86_64新版本，出现以下几个问题. 1. 没安装perl-DBD-MySQL $innobackupex --defaults-file=/db/mysql5.6/my.cnf -user=bkpuser -password=s3cret -socket=/db/mysql5.6/mysql.sock /hom

【MySQL】使用docker安装MySQL时的报错：Can't connect to local MySQL server through socket '/var/run/mysqld/mysql

热门推荐

走在搬砖的路上！

07-05

2万+

Ubuntu使用docker安装完mysql后登录时会遇到如下错误 root1@ubuntu:~$ mysql -uroot -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such fi...

docker中Can‘t connect to local MySQL server through socket

weixin_42814467的博客

05-27

3180

连接mysql的时候报这个错误。 ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (111) 解决办法如下：首先进入容器。 ###cd到mysqld文件夹下，命令如下： cd /var/run/mysqld/ ls查看一下，会看到这几个文件：mysqld.pid mysqld.sock mysqld.sock.lock 将mysqld.sock删除

docker连接数据库，ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/run/mysqld

szboy2003的博客

10-22

2020

Docler 连接Mysql, Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Docker安装mysql容器报错 Can‘t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock‘

weixin_41166529的博客

12-13

2379

Docker安装mysql容器报错 Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

Can‘t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock‘ (2)

llc580231的博客

03-12

986

完整报错：ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'(2)

docker启动mysql多实例连接报错Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’

刘大猫

10-21

2355

docker启动mysql多实例连接报错Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’