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
相關文章
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock錯誤MySqlServer
- linux下連線mysql報錯ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysqLinuxMySqlErrorServer
- mysql 啟動報錯Can't connect to local MySQL server through socket '/data/mysql/mysql/mysql.sock'(111)MySqlServer
- docker mysql mysqld: Error on realpath() on ‘/var/lib/mysql-files‘ No such file or directoryDockerMySqlError
- mysql執行報錯mysql.sockMySql
- [ERROR] mysqld: Can‘t open shared library ‘/usr/local/mysql/lib/plugin/validate_password.so‘ (errno:ErrorMySqlPlugin
- ubuntu解決Could not get lock /var/lib/dpkg/lock-frontendUbuntu
- E: 無法獲得鎖 /var/lib/apt/lists/lock - openAPT
- Linux報錯:Could not get lock /var/lib/dpkg/lock-frontendLinux
- 問題解決:無法獲得鎖 /var/lib/dpkg/lock
- Can't debug c++ project because unable to static library start program *.libC++Project
- sudo apt update時報錯 E: Unable to lock directory /var/lib/apt/lists/APT
- MySQL 2003 - Can’t connect to MySQL server on (10060)MySqlServer
- E: 無法獲得鎖 /var/lib/dpkg/lock-frontend - open (11: 資源暫時不可用) E: 無法獲取 dpkg 前端鎖 (/var/lib/dpkg/lock-front前端
- cadvisor報錯failed to collect filesystem stats- rootDiskErr: du command failed on /rootfs/var/lib/docAI
- Ubuntu 報錯:無法獲得鎖 /var/lib/dpkg/lock解決辦法Ubuntu
- E: 無法獲得鎖 /var/lib/dpkg/lock - open (11: 資源暫時不可用) E: 無法鎖定管理目錄(/var/lib/dpkg/),是否有其他程式正佔用它?
- E: 無法定位軟體包、E: 無法獲得鎖 /var/lib/dpkg/lock - open (11: 資源暫時不可用)、E: 無法鎖定管理目錄(/var/lib/dpkg/)
- mysqld: Can‘t create directory ‘E:\Software\mysql-5.7.24-winx64\data\‘ (Errcode: 2 - NoMySql
- Ubuntu中E: 無法獲得鎖 /var/lib/dpkg/lock - open (11: 資源暫時不可用) E: 無法鎖定管理目錄(/var/lib/dpkg/),是否有其他程式正佔用它?Ubuntu
- Ubuntu apt-get安裝時提示無法獲得鎖 /var/lib/dpkg/lock - openUbuntuapt-get
- mysql遇到Variable can’t be set to the value of ‘NULL’MySqlNull
- ubuntu:無法獲得鎖 /var/lib/dpkg/lock - open (11: 資源暫時不可用)Ubuntu
- 無法獲得鎖 /var/lib/dpkg/lock -open(11: 資源不可用) 解決方法
- Mac使用Docker時,卷預設掛載路徑/var/lib/docker/volumes不存在問題MacDocker
- 無法獲得鎖 /var/lib/dpkg/lock-frontend - open (11: 資源暫時不可用)
- 關於var a = 2; JS幹了什麼?JS
- E: 無法獲得鎖 /var/lib/dpkg/lock-frontend - open (11: 資源暫時不可用)
- Linux解決(無法獲得鎖 /var/lib/dpkg/lock - open (11: 資源暫時不可用))Linux
- Mysql:Variable 'XXXt' can't be set to the value of 'NULL'解決MySqlNull
- Ubuntu 解決E: 無法獲得鎖 /var/lib/dpkg/lock - open (11: 資源暫時不可用)Ubuntu
- 無法獲得鎖 /var/lib/dpkg/lock - open (11: 資源暫時不可用)的解決方法
- MYSQL報1022錯誤:Can't write;duplicate key in table '.....'MySql
- mysql中You can’t specify target table for update in FROM clMySql
- S2 - Lesson 57 - Can I help you, madam?
- ubuntu提示E: 無法獲得鎖 /var/lib/dpkg/lock-frontend - open (11: 資源暫時不可用)Ubuntu
- ubuntu 解決“無法獲得鎖 /var/lib/dpkg/lock -open (11:資源暫時不可用)”的方法Ubuntu
- 無法獲得鎖 /var/lib/dpkg/lock - open (11: 資源暫時不可用)問題的解決
- ubuntu 問題解決-----------無法獲得鎖 /var/lib/dpkg/lock - open (11: 資源暫時不可用)Ubuntu