Error: Failed to connect to MySQL server: DBI connect(';
2023-09-14 08:59:38 时间
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved. This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991. Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/p 150712 22:29:59 innobackupex: Executing a version check against the server...
150712 22:29:59 innobackupex: Connecting to MySQL server with DSN dbi:mysql:;mysql_read_default_group=xtrabackup as root (using password: YES).
innobackupex: got a fatal error with the following stacktrace: at /usr/bin/innobackupex line 3011.
main::mysql_connect(abort_on_error, 1) called at /usr/bin/innobackupex line 1551
innobackupex: Error: Failed to connect to MySQL server: DBI connect(;mysql_read_default_group=xtrabackup,root,...) failed: Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2) at /usr/bin/innobackupex line 2995.
150712 22:29:59 innobackupex: Connecting to MySQL server with DSN dbi:mysql:;mysql_read_default_group=xtrabackup as root (using password: YES).
innobackupex: got a fatal error with the following stacktrace: at /usr/bin/innobackupex line 3011.
main::mysql_connect(abort_on_error, 1) called at /usr/bin/innobackupex line 1570
innobackupex: Error: Failed to connect to MySQL server: DBI connect(;mysql_read_default_group=xtrabackup,root,...) failed: Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2) at /usr/bin/innobackupex line 2995. -------------------------------------------------------------------------------------------------------------------- 由上面可知道,innobackupex是通过socket的方式链接上去的。想办法使它不走socket就可以了。
解决: innobackupex -host=192.168.199.147 --user=jsb --password=jsb --defaults-file=/etc/my.cnf /data/backup
innobackupex + -host=本地路径 /data/backup是自己新建的备份露露
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved. This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991. Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/p 150712 22:29:59 innobackupex: Executing a version check against the server...
150712 22:29:59 innobackupex: Connecting to MySQL server with DSN dbi:mysql:;mysql_read_default_group=xtrabackup as root (using password: YES).
innobackupex: got a fatal error with the following stacktrace: at /usr/bin/innobackupex line 3011.
main::mysql_connect(abort_on_error, 1) called at /usr/bin/innobackupex line 1551
innobackupex: Error: Failed to connect to MySQL server: DBI connect(;mysql_read_default_group=xtrabackup,root,...) failed: Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2) at /usr/bin/innobackupex line 2995.
150712 22:29:59 innobackupex: Connecting to MySQL server with DSN dbi:mysql:;mysql_read_default_group=xtrabackup as root (using password: YES).
innobackupex: got a fatal error with the following stacktrace: at /usr/bin/innobackupex line 3011.
main::mysql_connect(abort_on_error, 1) called at /usr/bin/innobackupex line 1570
innobackupex: Error: Failed to connect to MySQL server: DBI connect(;mysql_read_default_group=xtrabackup,root,...) failed: Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2) at /usr/bin/innobackupex line 2995. -------------------------------------------------------------------------------------------------------------------- 由上面可知道,innobackupex是通过socket的方式链接上去的。想办法使它不走socket就可以了。
解决: innobackupex -host=192.168.199.147 --user=jsb --password=jsb --defaults-file=/etc/my.cnf /data/backup
innobackupex + -host=本地路径 /data/backup是自己新建的备份露露
相关文章
- Python——MySQL操作,使用mysql.connector
- Mysql授权允许远程访问解决Navicat for MySQL连接mysql提示客户端不支持服务器请求的身份验证协议;考虑升级MySQL客户端
- 用Navicat连接mysql报错:2003-Can't connect to MySql server on '10.100.0.109'(10039)
- 用习惯了Oracle,用起来MySql却非常的不方便!!
- mysql启动时报错:Starting MySQL... ERROR! The server quit without updating PID file (/opt/mysql/data/mysql.pid) 的解决方法
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
- MYSQL错误解决:ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
- [root@master mysql]# mysql -uroot -pjsb ERROR 2002 (HY000): Can't connect to local MySQL server thro
- 使用mysql-connector-python操作MYSQL数据库
- MySQL · 特性分析 · 优化器 MRR & BKA
- linux下mysql 5.5.38 源码安装笔记
- PHP连接MySQL数据库的三种方式(mysql、mysqli、pdo)--续
- PHP连接MySQL数据库的三种方式(mysql、mysqli、pdo)
- 连接Mysql提示Can’t connect to local MySQL server through socket的解决方法
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
- MySQL中的char和varchar&mysql中varchar能存多少汉字、数字,以及varchar(100)和varchar(10)的区别
- MYSQL导入数据报错|MYSQL导入超大文件报错|MYSQL导入大数据库报错:2006 - MySQL server has gone away
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket
- 解决ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
- MySQL技术内幕读书笔记(一)——Mysql体系结构和存储引擎
- 安全测试===Mysql 注入技巧学习 MySQL注入技巧(1)
- [MySQL] 解决办法: Error: Transaction test error: file /etc/my.cnf from install of mysql-community-server