How to solve the abnormal error ERROR: 2002 in mysql

Recently, an error occurred while starting MySQL. The error message is as follows:

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

Troubleshooting process

1. First check /etc/rc.d/init.d/mysqld status to see if mysql has been started.

Also check if it's a permissions issue.

2. Make sure your mysql.sock is in that location.

mysql -u yourmysqlusername -p -S /var/lib/mysql/mysql.sock

3. Try: service mysqld start

4. If it is a permission problem, change the permission first #chown -R mysql:mysql /var/lib/mysql

[root@localhost ~]# /etc/init.d/mysqld start
Start MySQL: [ OK ]
[root@localhost ~]# mysql -u root -p

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

The reason is the access permission problem of /var/lib/mysql.

shell> chown -R mysql:mysql /var/lib/mysql

Then start the server

shell> /etc/init.d/mysql start

After the server starts normally, check /var/lib/mysql and automatically generate the mysql.sock file.

But my problem is still not solved.

The problem is finally solved:

Method: Modify /etc/my.conf:

[mysqld]
datadir=/usr/local/mysql/data
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/usr/local/mysql

If there is not currently a section called [client], add one at the bottom of the file and copy the socket= line under the [mysqld] section such as:

[client]
socket=/var/lib/mysql/mysql.sock

I still found that the same thing happened. I ran /etc/init.d/mysql start and got an error: Starting MySQL Couldn't find MySQL manager or server. The mysqld service was not started. I ran /usr/local/mysql/bin/mysqld_safe &

Problem solved.

Summarize

Well, that’s all for this article. I hope that the content of this article can be helpful to your study or use of MySQL. If you have any questions, please leave a message to communicate. Thank you for your support of 123WORDPRESS.COM.