# Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' **URL:** \ **Category:** Other MySQL® Questions\ **Created:** [March 10, 2014, 10:13am UTC](https://forums.percona.com/t/cant-connect-to-local-mysql-server-through-socket-var-lib-mysql-mysql-sock/3324 "2014-03-10T10:13:16Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![i-CONICA](https://avatars.discourse-cdn.com/v4/letter/i/c68b51/32.png) [@i-CONICA](https://forums.percona.com/u/i-CONICA)\ **Post date:** [March 10, 2014, 10:13am UTC](https://forums.percona.com/t/cant-connect-to-local-mysql-server-through-socket-var-lib-mysql-mysql-sock/3324/1 "2014-03-10T10:13:16Z")
Hi, I’ve got a problem. I’m running Percona 5.5.35 on a LAMP stack. The application can communicate with the database just fine, but when I try to run automysqlbackup I get the error: ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) That’s the same socket path specified in my.cnf. Any help is much appreciated. Thanks. ---
**Author:** ![jagatveer](https://avatars.discourse-cdn.com/v4/letter/j/e36b37/32.png) [@jagatveer](https://forums.percona.com/u/jagatveer)\ **Post date:** [March 11, 2014, 6:04am UTC](https://forums.percona.com/t/cant-connect-to-local-mysql-server-through-socket-var-lib-mysql-mysql-sock/3324/2 "2014-03-11T06:04:47Z")
The error simply states that your MySQL is not available/running to accept any connection. Are you able to connect to MySQL via CLI when you get this error? What does the error logs say? ---
**Author:** ![niljoshi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/niljoshi/32/16889_2.png) [@niljoshi](https://forums.percona.com/u/niljoshi)\ **Post date:** [March 13, 2014, 1:32am UTC](https://forums.percona.com/t/cant-connect-to-local-mysql-server-through-socket-var-lib-mysql-mysql-sock/3324/3 "2014-03-13T01:32:03Z")
Hi, How you are running automysqlbackup? Is it possible for you to give socket details in that? Also as Jagatvir said, Is your MySQL running? In Linux, you can simply check with “ps -ef | grep mysql” I would also suggest to check that automysqlbackup is trying to connect to the same host which you are connecting through application. ---
**Author:** ![mixa](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mixa/32/16881_2.png) [@mixa](https://forums.percona.com/u/mixa)\ **Post date:** [March 13, 2014, 6:11am UTC](https://forums.percona.com/t/cant-connect-to-local-mysql-server-through-socket-var-lib-mysql-mysql-sock/3324/4 "2014-03-13T06:11:45Z")
As far as I could see: [url][http://sourceforge.net/projects/automysqlbackup/[/url]](http://sourceforge.net/projects/automysqlbackup/%5B/url%5D) It supports “socket” option. You can also check if the following exists in you mysql configuration (my.cnf) and if no then add it: [client] socket = /var/run/mysqld/mysqld.sock ---
**Author:** ![umarzuki](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/umarzuki/32/1064_2.png) [@umarzuki](https://forums.percona.com/u/umarzuki)\ **Post date:** [May 22, 2015, 2:17am UTC](https://forums.percona.com/t/cant-connect-to-local-mysql-server-through-socket-var-lib-mysql-mysql-sock/3324/5 "2015-05-22T02:17:54Z")
what if there is mysql.sock in path specified? ```auto $ sudo ls -l /var/lib/mysql/mysql.sock srwxrwxrwx 1 mysql mysql 0 Mei 22 15:42 /var/lib/mysql/mysql.sock ``` ---
**Author:** ![newman21](https://avatars.discourse-cdn.com/v4/letter/n/7bcc69/32.png) [@newman21](https://forums.percona.com/u/newman21)\ **Post date:** [September 28, 2018, 2:48am UTC](https://forums.percona.com/t/cant-connect-to-local-mysql-server-through-socket-var-lib-mysql-mysql-sock/3324/6 "2018-09-28T02:48:52Z")
Hello everyone. I need help with xtra backup software because I can’t create backup and error is similar to topicstarter’s error. Command: ```auto innobackupex --user=root --password=paassss --no-timestamp /home/aaa/28.09.18 ``` show me an error ```auto 180928 11:01:55 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: DBI connect(';mysql_read_default_group=xtrabackup','root',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at - line 1315. ``` Next try was to specify socket location: ```auto innobackupex --user=root --password=paassss --socket=/var/lib/mysql/mysql.sock --no-timestamp /home/aaa/28.09.18 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: /var/lib/mysql/mysql.sock Error: Unsupported server version: '5.7.23-23-log'. Please report a bug at https://bugs.launchpad.net/percona-xtrabackup lsb_release -a No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 18.04.1 LTS Release: 18.04 Codename: bionic apt-cache policy percona-xtrabackup percona-xtrabackup: Installed: 1:2.3.10-1.bionic Candidate: 1:2.3.10-1.bionic Version table: *** 1:2.3.10-1.bionic 500 500 http://repo.percona.com/apt bionic/main amd64 Packages 100 /var/lib/dpkg/status 2.4.9-0ubuntu2 500 500 http://archive.ubuntu.com/ubuntu bionic/universe amd64 Packages ``` ---
**Author:** ![Deon\_Joubert1](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/deon_joubert1/32/3659_2.png) [@Deon\_Joubert1](https://forums.percona.com/u/Deon_Joubert1)\ **Post date:** [August 13, 2021, 2:25pm UTC](https://forums.percona.com/t/cant-connect-to-local-mysql-server-through-socket-var-lib-mysql-mysql-sock/3324/7 "2021-08-13T14:25:29Z")
Thanks - this helped me get going with XtraBackup in 2021 for the first time! (specficialy the part about adding the socket entry to [client])