i was just checking somethings and noticed mysqld is not running in parallels power panel control panel...but my websites on the server were all working fine, which use mysql databases...so really strange

So i tried to restart mysqld but got errors and can't restart and now all my websites are all offline now saying error connecting to database.

logged in as root and tried

/etc/init.d/mysqld start

and got this error

ERROR! Manager of pid-file quit without updating file

What do i do next?

What do i do? Please help!

migrated from stackoverflow.com Nov 20 '11 at 16:26

This question came from our site for professional and enthusiast programmers.

  • look at MySQL log, normally in /var/log/mysql.log or /var/log/mysql/mysql.log – stivlo Nov 13 '11 at 7:05
  • and do what next? what do i do when i look at it? please explain – grant tailor Nov 13 '11 at 7:07
  • at the end of that file, there might be an error. copy it here and you can get better help. – stivlo Nov 13 '11 at 7:08
  • how do i see the file again because not working vi /var/log/mysql.log but don't see anything....also can i use nano editor" tried nano /var/log/mysql.log but got -bash: nano: command not found – grant tailor Nov 13 '11 at 7:12
  • u still there ? – grant tailor Nov 13 '11 at 7:16

Is your hard drive out of space? Run:

df -h

Or try renaming /etc/my.cnf to /etc/my.cnf.old and it'll rebuild a new my.cnf.

It may also be in the /etc/mysql/my.cnf directory


After chatting, we figured out that mysql was still running. Apparently, some people have reported this error message is caused when mysql doesn't shut down properly, but thinks it's shut down.

So we ran

ps aux | grep mysqld

To see running processes, then,

kill 23445 34255

To stop the processes...

Then /etc/init.d/mysqld start

to start the server back up.

  • no hard drive has 94GB free – grant tailor Nov 13 '11 at 7:07
  • What about renaming the my.cnf file? – Homer6 Nov 13 '11 at 7:09
  • how do i rename the my.cnf file and where do i see the my.cnf file? – grant tailor Nov 13 '11 at 7:09
  • ls -lah /etc/my.cnf OR ls -lah /etc/mysql THEN mv /etc/my.cnf /etc/my.cnf.old – Homer6 Nov 13 '11 at 7:14
  • i mean i am not trying do anything that will cause arm or i cannot reverse...so if i rename that file...will i be able to reverse that? and what will that do really? – grant tailor Nov 13 '11 at 7:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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