Номер ошибки 2002

I’m getting this error

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


even though I have managed to start mysql via command line in ubuntu

mysql stop/waiting
mysql start/running, process 17691

However when attempting to access the site I get a database connection error as well as the above error when trying to access mysql via mysql -u root -p

I checked my error logs and I saw this

    131029 12:53:34 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be remo$
    131029 12:53:34 [Note] Plugin 'FEDERATED' is disabled.
    131029 12:53:34 InnoDB: The InnoDB memory heap is disabled
    131029 12:53:34 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    131029 12:53:34 InnoDB: Compressed tables use zlib 1.2.3.4
    131029 12:53:34 InnoDB: Initializing buffer pool, size = 26.0G
    131029 12:53:36 InnoDB: Completed initialization of buffer pool
    131029 12:53:36 InnoDB: highest supported file format is Barracuda.
    131029 12:53:38  InnoDB: Waiting for the background threads to start
    131029 12:53:39 InnoDB: 5.5.34 started; log sequence number 5146431500
    131029 12:53:39 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    131029 12:53:39 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    131029 12:53:39 [Note] Server socket created on IP: '0.0.0.0'.
    131029 12:53:39 [Note] Event Scheduler: Loaded 0 events
    131029 12:53:39 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.34-0ubuntu0.12.04.1-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)

It’s the first time I see this error and I’m not sure how to solve this issue, please help me out a bit here.

Thanks

UPDATE

Okay I tried glglgl’s solution and after a restart, I get the following in the error log:

    131029 13:17:36 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be remo$
    131029 13:17:36 [Note] Plugin 'FEDERATED' is disabled.
    131029 13:17:36 InnoDB: The InnoDB memory heap is disabled
    131029 13:17:36 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    131029 13:17:36 InnoDB: Compressed tables use zlib 1.2.3.4
    131029 13:17:36 InnoDB: Initializing buffer pool, size = 26.0G
    131029 13:17:38 InnoDB: Completed initialization of buffer pool
    131029 13:17:38 InnoDB: highest supported file format is Barracuda.
    131029 13:17:40  InnoDB: Waiting for the background threads to start
    131029 13:17:41 InnoDB: 5.5.34 started; log sequence number 5146431500
    131029 13:17:41 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
    131029 13:17:41 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
    131029 13:17:41 [Note] Server socket created on IP: '127.0.0.1'.  
    131029 13:17:41 [Note] Event Scheduler: Loaded 0 events
    131029 13:17:41 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.34-0ubuntu0.12.04.1-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)

asked Oct 29, 2013 at 12:58

This took me ages to figure out but could you try the same —

1 — Update and Upgrade

sudo apt-get update
sudo apt-get upgrade

2 — Purge MySQL Server and Client (if installed).

sudo apt-get purge mysql-server mysql-client

3 — Install MySQL Server and Client fresh

sudo apt-get install mysql-server mysql-client

4 — Test MySQL

mysql -u root -p
> enter root password

*** should get socket not found in /var/run/mysqld/mysql.sock

4 — Configure mysqld.cnf with nano of vi

sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

Change bind-address from 127.0.0.1 to localhost

bind-address            = localhost

** Write and Exit

5 — Restart MySQL

sudo /etc/init.d/mysql restart

6 — check mysql

mysql -u root -p
> enter root password

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.13-0ubuntu0.16.04.2 (Ubuntu)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

You should get in to mysql cli now.

Hope this helps

Code.Ph0y

answered Sep 10, 2016 at 4:56

In the linux terminal, I run the following steps and they helped me out

1.First of all list all the mysql packages installed

  sudo dpkg -l | grep mysql

2.Delete the listed packages with the listed command

  sudo apt-get --purge autoremove <package name>

3.Reinstall mysql server

  sudo apt-get install mysql-server

This worked for me, Hope this works for you aswell.

Alternatively Try

sudo apt-get remove --purge mysql-\

then reinstall with

sudo apt-get install mysql-server mysql-client

answered Jan 2, 2018 at 12:02

I had the problem.

This process worked for me:

Ensure that during remove process you choose No to deleting database.

sudo apt-get remove --purge mysql*

sudo apt-get autoremove

sudo apt-get autoclean

sudo apt-get install mysql-server mysql-client

I had the same problem after altering my.cnf. I resolved this problem next steps.

First : to find the location of error.log, look at ‘my.conf’.

Second : I looked up error.log, I found next massages,

«unknown variable ‘default-……’ »
…..
» mysqld_safe Starting mysqld darmon with from /var/lib/mysql «

Third : I reset my.conf to the default, then restart, this problem was resolved.

I hope this helps.

answered Mar 3, 2014 at 3:43

this worked for me

sudo /etc/init.d/mysql start

first i tried this, but i dont understand why it doesn’t work this way

sudo service mysql start

answered Aug 27, 2016 at 16:10

There is another chance of you to get this particular error if you modify the max_connections in my.cnf file.

I also faced the same error which did not let me log in to MySQL server. In my case the problem was, I had to increase the max_connections size in

/etc/mysql/my.cnf

to

set-variable = max_connections = 5000

Due to this reason next day when I stared MySQL server it threw this error

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Removing the set-variable = max_connections = 5000 segment from my.conf file did the trick. After removing that particular segment following command was used. MySQL server started up and running like previously.

sudo /etc/init.d/mysql start

answered Feb 8, 2015 at 3:01

Try this:

sudo dpkg-reconfigure mysql-server-{version_number}

version_number should be mysql version number. For example

sudo dpkg-reconfigure mysql-server-5.6

Then access mysql like this:

mysql -u root -p

If you are using wsl on windows 10 with ubuntu you can run:

• sudo /etc/init.d/mysql start
  the command sudo service start mysql wont work because you need to configure it. You can find how here

answered Nov 21, 2021 at 17:45

Two main reasons:

1) mysql-server isn’t installed! You have to install it (mysql-server and not mysql-client) and run it.

2) It’s installed by default and running. So, it’s not possible to run it again through Xampp or Lampp. You have to stop it:
sudo service mysql stop

then you can start it through Xampp.
It’s possible to check if it’s running or not with this code:
sudo netstat -tap | grep mysql

If you see a result like this:
tcp 0 0 localhost:mysql : LISTEN 1043/mysqld

It means that it’s running properly.

answered Jul 26, 2015 at 21:49

answered Oct 7, 2015 at 13:46

answered Dec 4, 2015 at 13:57

Simple:
run these codes:::

 1:: ls -lart/var/run/my*

   2::mkdir /var/run/mysqld

    3::touch /var/run/mysqld/mysqld.sock
    4:ls -lart /var/run/mysqld
    5::chown -R mysql /var/run/mysqld
    6::ls -lart /var/run/mysqld
REstart your mysql server

then finaly type mysql -u root or mysql -u root -p and press enter key. thanks

answered Mar 1, 2016 at 23:34

Note that I ran into this trouble after I upgraded my Ubuntu 14.04 distribution using apt-get upgrade. I had to completely purge mysql-server and mysql-client and reinstall it to fix this issue.

sudo apt-get autoremove
sudo apt-get autoclean
sudo apt-get purge mysql-server mysql-client
sudo apt-get install mysql-server mysql-client

Hope this helps.

answered Aug 6, 2016 at 20:38

I was stuck with this error too, and it took almost 3 hours to find it.

First of all, try to recall the changes that you made to your conf file, then undo the changes and save the file and start mysql. If you want to make any changes to the conf file, then stop mysql server and then change the desired values and restart mysql.

This error occurs because of an incorrect (wrong keyword or wrong value assigned) change made to the conf file. Most of the times this error occurs even if you restart the machine running the server, as the server is stopped, in that case, start mysql server.