Can't connect to local MySQL through socket '/tmp/mysql.sock' solution

Error message:

ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)

Solution:

/usr/local/mysql/bin/mysqladmin -u root > -S /var/lib/mysql/mysql.sock password 'your.passwd'

Or make a soft link

ln -s /var/lib/mysql/mysql.sock /tmp

reason:

In fact, the prompt that /tmp/mysql.sock cannot be found sometimes does not mean that the file does not exist in the /tmp directory, but that the startup command is incorrect.

/usr/local/mysql/bin/mysql -u root -p
/usr/local/mysql/bin/mysqld --user=mysql&
/usr/local/mysql/bin/mysqld --user=root&
/usr/local/mysql/bin/mysqld_safe --user=root&
/usr/local/mysql/bin/mysqld_safe --user=mysql&
/usr/local/mysql/bin/safe_mysqld--uer=root& (note that safe_mysqld is different from mysqld_safe, & means mysql is running in the background)

Error message:

STOPPING server from pid file /usr/local/mysql/data/localhost.localdomain.pid 060304 11:46:21 mysqld ended

Solution:

This is a permission issue. My mysql directory belongs to the root user and the root group. I can start it with mysqld_safe and it works fine. Just pay attention to these commands: mysql, safe_mysqld, mysqld_safe, mysqld, mysqladmin. Try several times. Sometimes mysql has started normally. Check whether mysql is started with the command

ps -aux | grep mysqld

You will see something similar to the following

mysql 6394 0.0 1.5 10528 992 pts/3 S 16:16 0:00
/usr/local/mysql/mysql 6395 0.0 1.5 10528 992 pts/3 S 16:16 0:00
/usr/local/mysql/mysql 6396 0.0 1.5 10528 992 pts/3 S 16:16 0:00
/usr/local/mysql/root 6422 0.0 1.1 2408 732 pts/3 S 16:20 0:00 grep mysql

Check if mysql is listening on the port command

netstat -tl | grep mysql

You will see something similar to the following

tcp 0 0 *:mysql *:* LISTEN

Summarize

The above is the full content of this article. I hope that the content of this article will have certain reference learning value for your study or work. Thank you for your support of 123WORDPRESS.COM. If you want to learn more about this, please check out the following links