Can'tconnecttolocalMySQLserverthroughsocket'/var/lib/mysql/mysql.sock'(2)
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
160309 07:01:49 innobackupex: Executing a version check against the server…
160309 07:01:49 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: Can`t connect to local MySQL server through socket `/var/lib/mysql/mysql.sock` (2) at /usr/bin/innobackupex line 2995
160309 07:01:49 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: Can`t connect to local MySQL server through socket `/var/lib/mysql/mysql.sock` (2) at /usr/bin/innobackupex
line 2995
[root@t1 /]# ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock
ln: creating symbolic link `/var/lib/mysql/mysql.sock`: No such file or directory
解決:
[root@t1 /]# mkdir /var/lib/mysql/
[root@t1 /]# ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock
[root@t1 /]# ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock
相關文章
- error:'Can'tconnecttolocalMySQLserverthroughsocket'/var/lib/mysql/mysql.sock'(2)'ErrorMySqlServer
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock錯誤MySqlServer
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)解決方法MySqlServer
- 更換mysql資料目錄後出現ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 的解決辦法MySqlErrorServer
- 解決Can 't connect to local MySQL server through socket '/tmp/mysql.sock '(2) "MySqlServer
- Can't connect to local MySQL server through socket '/tmp/mysql.sock'MySqlServer
- "locate: can not open `/var/lib/mlocate/mlocate.db"問題解決
- docker mysql mysqld: Error on realpath() on ‘/var/lib/mysql-files‘ No such file or directoryDockerMySqlError
- ERROR 2002(HY000):Can't connect to local MySQL socket '/tmp/mysql.sock'ErrorMySql
- mysql 啟動報錯Can't connect to local MySQL server through socket '/data/mysql/mysql/mysql.sock'(111)MySqlServer
- linux下連線mysql報錯ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysqLinuxMySqlErrorServer
- mysql.sock的作用MySql
- ERROR 2002 (HY000): Can't connect server socket /tmp/mysql.sockErrorServerMySql
- mysql執行報錯mysql.sockMySql
- mysql報CanMySql
- 【MySQL】Can't get stat of './mysql/slow_log.CSV' (Errcode: 2)MySql
- E: 無法獲得鎖 /var/lib/apt/lists/lock - openAPT
- Check mod for temporary file : /usr/local/centreon/var/lib/centplugins/Plugin
- 問題解決:無法獲得鎖 /var/lib/dpkg/lock
- Linux報錯:Could not get lock /var/lib/dpkg/lock-frontendLinux
- sudo apt update時報錯 E: Unable to lock directory /var/lib/apt/lists/APT
- [ERROR] mysqld: Can‘t open shared library ‘/usr/local/mysql/lib/plugin/validate_password.so‘ (errno:ErrorMySqlPlugin
- Ubuntu Could not get lock /var/lib/apt/lists/lock - open (11: Resource temporarily unavailable)UbuntuAPTAI
- E: 無法獲得鎖 /var/lib/dpkg/lock-frontend - open (11: 資源暫時不可用) E: 無法獲取 dpkg 前端鎖 (/var/lib/dpkg/lock-front前端
- Ubuntu 報錯:無法獲得鎖 /var/lib/dpkg/lock解決辦法Ubuntu
- Can't debug c++ project because unable to static library start program *.libC++Project
- E: 無法獲得鎖 /var/lib/dpkg/lock - open (11: 資源暫時不可用) E: 無法鎖定管理目錄(/var/lib/dpkg/),是否有其他程式正佔用它?
- E: 無法定位軟體包、E: 無法獲得鎖 /var/lib/dpkg/lock - open (11: 資源暫時不可用)、E: 無法鎖定管理目錄(/var/lib/dpkg/)
- 啟動mysql時顯示:/tmp/mysql.sock 不存在的解決方法MySql
- 解決不能透過mysql.sock連線MySQL問題的辦法(轉)MySql
- Ubuntu中E: 無法獲得鎖 /var/lib/dpkg/lock - open (11: 資源暫時不可用) E: 無法鎖定管理目錄(/var/lib/dpkg/),是否有其他程式正佔用它?Ubuntu
- 【MySQL】ERROR 1093 You canMySqlError
- 【MySQL】Slave can not handle replication events with the checksum ...MySql
- Ubuntu apt-get安裝時提示無法獲得鎖 /var/lib/dpkg/lock - openUbuntuapt-get
- mysqld: Can‘t create directory ‘E:\Software\mysql-5.7.24-winx64\data\‘ (Errcode: 2 - NoMySql
- [ERROR] Can't open the mysql.plugin tableErrorMySqlPlugin
- mysql遇到Variable can’t be set to the value of ‘NULL’MySqlNull
- mysql can't start dues to the disk space is fullMySql