bloggerspoint
By:
bloggerspoint

CentOS MySQL server won't start

January 11, 2015 25.1k views

Hey,

I have installed MySQL on my CentOS 7 server, but it won't start. When i try to start it with the command "sudo service mysqld start" i get the message "Job for mysqld.service failed. See 'systemctl status mysqld.service' and 'journalctl -xn' for details." after about 5 minutes.

I have searched Google all day, and just can't find a solution..

Log:
150111 10:06:40 mysqldsafe A mysqld process already exists
150111 10:20:35 mysqldsafe A mysqld process already exists
150111 10:30:35 mysqldsafe A mysqld process already exists
150111 10:40:35 mysqldsafe A mysqld process already exists

Please help...

1 comment
  • sierracircle January 11, 2015

    I am not familiar with CentOS, but had a similar issue in Ubuntu. I was able to use this:

    /etc/init.d/mysql stop
    /etc/init.d/mysql start

Log In to Comment
3 Answers
JonsJava January 12, 2015

You are running CentOS 7. Run this:

systemctl status mysqld.service

If no errors show up, try this:

systemctl restart mysqld.service

If that fails, run this:

for i in `ps auxf|grep mysqld|grep "grep" -v|awk '{print $2}'`; do kill -9 $i; done

Then, run this:

systemctl start mysqld.service

And finally, to ensure it is working:

systemctl status mysqld.service
Reply
admin1048934 May 27, 2015
[deleted]
Reply
sizwan March 3, 2018

Reinstalling MySQL might help.
First uninstall,
then delete the /var/lib/mysql and /etc/my.cnf or /etc/my.cnf.rpmsave,
then Restart,
then Install.

Reply
Have another answer? Share your knowledge.