Technical Solution

[SOLVED] Can't Connect to Local MySQL Server Through Socket '/var/run/mysqld/mysqld.sock

Deepak.r | | 1 min read

Have you ever faced an error 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock', while trying to log in to MySQL as any user?

You can login to your MySQL via the following terminal command.

mysql -u root -p

or

mysql -u root -pPassword

Its recommended, not to use passwords in terminal command, due to privacy reasons.

Verify that, your MySQL is running. If not, start service by typing following command in your Linux terminal.

sudo service mysql start

or

/etc/init.d/mysql start

This error occurs due to multiple installations of MySQL, in the operating system.

To resolve the issue, run the following commands in your Linux terminal.

ps -A|grep mysql

Kill the process by using following command:

sudo pkill mysql

and then run command:

ps -A|grep mysqld

Also Kill this process by running the following command:

sudo pkill mysqld

Now you are fully set and can restart your MySQL server by running the following commands:

sudo service mysql restart
mysql -u root -p

Hope this helps!

 

 

Related Topics