Centos fails to launch mysql

Asked 3 months ago, Updated 3 months ago, 5 views

When I try to start mysql at the terminal, I get an error similar to the following:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket'/tmp/mysql.sock'(2)

I tried the following solution, but it was impossible.

Please tell me the cause and how to solve it


2022-09-30 14:26

1 Answers

(2) in the error message indicates the error number.
Issue the error command in order to know what the error number means.

OS error code 2: No such file or directory

In other words, there is no /tmp/mysql.sock.

Possible causes include:

Mysqld has not started.

You may want to check if mysqld is started using the ps command.

The location of the mysql.sock file used by the mysqld and mysql commands during startup is different.

Socket files used by the mysqld command can be found in mysqld --help-v | grep^socket.

2022-09-30 14:26

If you have any answers or tips

© 2023 OneMinuteCode. All rights reserved.