Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I woke up this morning to find MySQL down on my personal CentOs server, but I don't seem to be able to start it again?!?

Starting (well restarting...):

root@tent:~$ /sbin/service mysqld restart
 ERROR! MySQL manager or server PID file could not be found!
Starting MySQL............................................................................................................... ERROR! Manager of pid-file quit without updating
root@tent:~$ /sbin/service mysqld status
 ERROR! MySQL is running but PID file could not be found

Tail of error log (nothing relevant)

tail -f /var/lib/mysql/tent.err
110302 12:43:39 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.55'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server
110305 17:52:04 mysqld_safe mysqld from pid file /var/lib/mysql/tent.pid ended

Trying safe mode instead:

/usr/bin/mysqld_safe
120502 08:01:54 mysqld_safe Logging to '/var/lib/mysql/mysql-bin.err'.
120502 08:01:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120502 08:03:38 mysqld_safe mysqld from pid file /var/lib/mysql/tent.pegproductions.com.pid ended

So I'm left with these running, but MySQL is still 'down' (phpMyAdmin fails, as do PHP web apps).

root@tent:/var/lib/mysql$ ps aux | grep -i mysql
root      1599  0.0  0.0   3712  1308 ?        S    Apr30   0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/tent.pid
mysql     1666  0.0  0.9 130000 19356 ?        Sl   Apr30   0:08 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/mysql-bin.err --pid-file=/var/lib/mysql/tent.pid
root     11452  0.0  0.0   3224   776 pts/0    S+   08:07   0:00 grep -i mysql

As far as I am aware I haven't changed anything and yet it no longer starts?

Do you have any idea why or what further information I can provide?


root@tent:~$ file /var/lib/mysql/tent.pid
/var/lib/mysql/tent.pid: ASCII text
root@tent:~$ cat /var/lib/mysql/tent.pid
1672
share|improve this question

closed as off-topic by HopelessN00b Apr 9 at 18:33

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions on Server Fault must be about managing information technology systems in a business environment. Home and end-user computing questions may be asked on Super User, and questions about development, testing and development tools may be asked on Stack Overflow." – HopelessN00b
If this question can be reworded to fit the rules in the help center, please edit the question.

    
Result for file /var/lib/mysql/tent.pid? –  Bart De Vos May 2 '12 at 7:14
    
Added above for you –  Pez Cuckow May 2 '12 at 7:31

1 Answer 1

up vote 2 down vote accepted

Try the following:

 kill -15 1666
 kill -15 1599
 rm  /var/lib/mysql/tent.pid
 rm /var/lib/mysql/tent.pegproductions.com.pid
 service mysqld start
share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.