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

I can't start mysql due to this error:

 ERROR! MySQL manager or server PID file could not be found!
Starting MySQL.. ERROR! Manager of pid-file quit without updating file.

how can I fix this please?

share|improve this question
    
You should take a look at the error log: /var/log/mysqld.log. –  quanta Sep 15 '12 at 13:58
    
Thanks, it a cPanel server. cat: /var/log/mysqld.log: No such file or directory –  Zim3r Sep 15 '12 at 14:04
    
grep error /etc/my.cnf? –  quanta Sep 15 '12 at 14:06
    
Thanks but nothing. –  Zim3r Sep 15 '12 at 14:08
1  
Insert it (log-error = /var/log/mysqld.log) into the [mysqld] section then try again and post the log here. –  quanta Sep 15 '12 at 14:10

1 Answer 1

up vote 1 down vote accepted

Depending on the OS - the MySQL logs will be in varying locations and not always what is dictated in my.cnf.

Debian for example will put them in /var/log/syslog

CentOS/Redhat will put them in /var/lib/mysql/__hostname__.err

etc.

But you can actually just start the MySQL daemon without using service or init.d and just execute the command directly. This will print any/all of your errors to stdout

Eg. mysqld

Typically, for the error you have, it is because of permissions issues with the MySQL daemon being able to write to the pid file.

Debian will put them in /var/run/mysqld/mysqld.pid

CentOS/Redhat will put them in /var/lib/mysql/mysql.pid

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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