Skip to content
Advertisement

MySQL Daemon Failed to Start – centos 6

EDIT: Look at the checkmarked answer comments to get your issue solved.

Whenever I try to start the SQLD service I get MySQL Daemon Failed to Start. I infact tried to “start” the service by doing the following:

JavaScript

Also

When I type: mysql

I get:

JavaScript

I know that there should be a mysql.sock file in that directory, so I create one. But the file just auto removes its self and I continue to get the error 2002.

I am also unable to log into PHPMyAdmin due to the error. I can access phpmyadmin page but when logging in I get: #2002 Cannot log in to the MySQL server

EDIT:

Here is my mysql.log file:

JavaScript

I ran mysql_upgrade and got

JavaScript

Advertisement

Answer

The most likely cause for this error is that your mysql server is not running. When you type in mysql you are executing mysql client.

Try:

JavaScript

Update (after OP included log in the question; taken from the comments below):

Thanks, saw your log. The log is saying the mysql user doesn’t have proper access rights. I’m assuming your mysql user is mysql(this can be verified in /etc/my.cnf, execute

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

and try starting mysqld again.

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement