ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) Ubuntu

Question

I have checked status of mysql by sudo service mysql status and get the following output:

 mysql.service - LSB: Start and stop the mysql database server daemon
   Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled)
   Active: active (exited) since Fri 2016-07-22 15:06:35 IST; 11s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 4946 ExecStart=/etc/init.d/mysql start (code=exited, status=0/SUCCESS

Jul 22 15:06:35 ubuntu-lenovo systemd[1]: Starting LSB: Start and stop the mysql
Jul 22 15:06:35 ubuntu-lenovo systemd[1]: Started LSB: Start and stop the mysql

But when I try it to run via terminal it says:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

When I try to run with host i.e. mysql --host 127.0.0.1 -uroot it says:

ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)

I have tried almost every solution from SO.

Try restarting MySQL and Apache services – Saurabh Jul 22 '16 at 09:43 — Saurabh, Jul 22 '16 at 09:43
Show your **mysql.sock** page? – Nana Partykar Jul 22 '16 at 09:45 — Nana Partykar, Jul 22 '16 at 09:45
where is mysql.sock file? – عثمان غني Jul 22 '16 at 09:49 — عثمان غني, Jul 22 '16 at 09:49
I gave my answer. Go through it step by step. – Nana Partykar Jul 22 '16 at 09:50 — Nana Partykar, Jul 22 '16 at 09:50
didn't work even after purging, reinstalling mysql – عثمان غني Jul 22 '16 at 10:47 — عثمان غني, Jul 22 '16 at 10:47
worked now after manually starting mysql – عثمان غني Jul 22 '16 at 10:56 — عثمان غني, Jul 22 '16 at 10:56

score 1 · Answer 1 · answered Jul 22 '16 at 09:47

Simply check your my.cnf (mysql configuration file) and change from

bind-address = 0.0.0.0

to

bind-address = 127.0.0.1

if you don't have that parameter just add it.

Binding to the 0.0.0.0 let your mysql being available on every IP configured cause you can't bind just on two or three IP on the server, the config can be: localhost or everything.

Then check your /etc/hosts file and be sure that the line

127.0.0.1 localhost

Next, restart your mysql

service mysql restart

score 0 · Answer 2 · edited May 23 '17 at 11:54

Find your php.ini file in your system using $ php -i |grep php\.ini command OR Find Using this Link
Open php.ini file.
And, make sure these lines are present or not.

a) extension=mysql.so b)extension=pdo_mysql.so
If Yes, remove (;) this before them.
If not present, run this command sudo apt-get install php5-mysql

Now, type php artisan migrate command. I'm sure you will get error

can't connect to local MYSQL server through socket

Now,

Change bind-address from localhost to 127.0.0.1
Run /opt/lampp/bin/php.
After running this if you get

"unable to load dynamic library"

Then, remove php_mssql.dll extension (for non-windows)

If not getting error, come directly to Project-Name-Folder/config/database.php file and add this code 'unix_socket' => '/opt/lampp/var/mysql/mysql.sock',

Find the complete path of mysql.sock, and add it

'mysql' => [
    'driver'    => 'mysql',
    'host'      => env('DB_HOST', 'localhost'),
    'database'  => env('DB_DATABASE', 'danishLara'),
    'username'  => env('DB_USERNAME', 'root'),
    'password'  => env('DB_PASSWORD', ''),
    'unix_socket'   => '/opt/lampp/var/mysql/mysql.sock', //Add this line here
    'charset'   => 'utf8',
    'collation' => 'utf8_unicode_ci',
    'prefix'    => '',
    'strict'    => false,
],

Could not open input file: artisan on running php artisan migrate — عثمان غني, Jul 22 '16 at 09:56
@عثمانغني: Open `'/opt/lampp/var/mysql/mysql.sock',` and add `'unix_socket' => '/opt/lampp/var/mysql/mysql.sock',` — Nana Partykar, Jul 22 '16 at 09:57

score 0 · Answer 3 · answered Jul 20 '20 at 00:26

0

This could happen after the homebrew installation and sometimes occurs due to permission issues. The following commands fixed the same problem on my computer.

sudo chown -R _mysql:mysql /usr/local/var/mysql

sudo mysql.server start

answered Jul 20 '20 at 00:26

Alexander Surdushkin

1
1

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) Ubuntu

3 Answers3