JAVA高级面试进阶训练营视频教程

admin

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

 备注：百度好久出来的答案简直呵呵呵，重复率极高，必应搜到的答案，解决了我的问题