ERREUR 2002 (HY000) : Solved

Question

Hello,

when I try to restart MySQL on Linux, I get this error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

could you help me?

thank you for your response

lemaire

mamiemando · Accepted Answer

In my opinion, there is an error or inconsistency in /etc/mysql/my.cnf if you don't have the file /var/run/mysqld/mysqld.sock.

Typically, you should have something like this:

.... # This was formally known as [safe_mysqld]. Both versions are currently parsed. [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] # # * Basic Settings # user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/english skip-external-locking ...

Backup /etc/mysql/my.cnf beforehand, just in case.

To regenerate this file, you can reinstall the package. Normally, under Debian/Ubuntu, you just need to run:

sudo dpkg-reconfigure mysql-server sudo service mysql restart

If that doesn't change anything, reinstall the package. For example, under Debian, Ubuntu, etc...

sudo apt-get update sudo apt-get install aptitude sudo aptitude update sudo aptitude safe-upgrade sudo rm /etc/mysql/my.cnf sudo aptitude reinstall mysql-server

Good luck.

rescue · Answer

Hello,

I think it's a MySQL problem that stopped quite abruptly.
Check for the presence of the mysqld.sock file.

See you later

--

Better to seem 'STUPID' for 5 minutes than to remain so for the rest of your life.

lemaire · Answer

the file does not exist I searched for it and did not find it  how am I going to install it?

lemaire · Answer

In fact, the mentioned file does not exist. How can I install it since the mysql client and server are already installed?

How can I get the file?

Note: There is already a mysqld session in the my.cnf file.

Thank you for your reply.

rescue · Answer

RE,  1 - run a netstat -plantu | grep 3306 If you don't see anything, it means mysql is not started.  2 - the file is located in: /var/lib/mysql/mysql.sock   3 - start Mysql: /etc/init.d/mysql start  If that doesn't work, then uninstall and reinstall mysql-server.  @+  --  Better to seem 'STUPID' for 5 minutes than to remain so for your entire life.

lemaire · Answer

Hi,

Here's the message I get when I try this command sudo /etc/init.d/mysql restart

message:
Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql restart

Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the restart(8) utility, e.g. restart mysql
mysql start/running, process xxx

When I use service mysql restart it tells me: mysql start/running, process xxx

Everything seems fine, I think, mysql is running but the problem is that I can't connect to my database. When I try to connect, it says: failed to connect to the database.

rescue · Answer

Hello,

Have you checked with the netstat command that MySQL is indeed listening on port 3306?
Are you sure about the login and password?
How do you connect to MySQL? (With a lightweight client like phpMyAdmin or via command line)

Try the following command: ps -aux | grep mysql
and give us the result.

@+

--

Better to look 'STUPID' for 5 minutes than to remain one for a lifetime.

lemaire · Answer

Hello, rescue

When I run root@xxx:/# sudo netstat -planu | grep 3306
or
root@xxx:/# sudo netstat -planu | grep 3306

it returns to the command line, that is to say:
root@xxx:/#

I don't understand. Does this mean that it's listening on port 3306?

Thank you for your reply.

lemaire · Answer

Hello, rescue

root@xxx:/# sudo ps aux | grep mysql

I have these values that I just masked because I don't know what they are

mysql xxx x.x xxx xxxxx ? Ssl xx:xx x:xx /usr/sbin/mysqld
root xxxx x.x x.x xxx xxx pts/1 S+ xx:xx x:xx grep --color=auto mysql

Thank you

lemaire · Answer

Hello rescue  When I try these commands, here's what I get  root@xxx:/# netstat -a | grep 3306 root@xxx:/# netstat -an | grep 3306 tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN

lemaire · Answer

I'm trying in the command line.

rescue · Answer

Re,

With the command:
sudo ps aux | grep mysql
This displays the mysql processes that are running.

Then kill these processes with the command kill
sudo kill -9 numero_PID

Then run: sudo ps aux | grep mysql
to check that there are no more mysql processes running

Then do a: sudo service mysql start
then restart with: netstat -a | grep 3306

Also check that the .sock is in /var/lib/mysql/mysql.sock

@+

--

Better to look 'STUPID' for 5 minutes than to remain one for a lifetime.

lemaire · Answer

Hello I followed your instructions. The problem is that neither MySQL nor Apache can start  and the mysql.so no longer exists.

rescue · Answer

Hello,

I don't see at all where your problem is, it's becoming very very confusing.

Do you know that killing a running MySQL process has no impact on Apache?
These are two independent software programs.

I apologize in advance, you must have made a mistake.
My instructions are not meant to break your machine.
Because what I write, I also do on my Linux server and it's still alive.

I don’t know what else to tell you, my poor friend, other than to reinstall.
I am truly sorry.

See you soon...

--

Better to seem 'STUPID' for 5 minutes than to remain one for the rest of your life.

lemaire · Answer

Hello, just a thank you because your help has been invaluable  have a good day and see you soon

ERREUR 2002 (HY000) :

15 réponses

Windows spotlight is not working.

Masked destination layer

Samsung j5 unable to answer

Scam of the suvedene highway

File name too long

No sound with ps3 and hdmi

Wake up from sleep mode in windows 10.

Internet connection problem with my ipad

Free box: remote control broken

Suspicious number text message