Solution: "MySQL is running but PID file could not be found"

If sometime, mysql status shows that "ERROR! MySQL is running but PID file could not be found", after checking the mysql status like below:
etc/init.d/mysql status
ERROR! MySQL is running but PID file could not be found

To solve this issue, please kill all the mysql daemon.
ps aux | grep mysql
kill -9 pid1 pid2 ...
Now start the mysql,
/etc/init.d/mysql start 

Comments

Post a Comment

Popular posts from this blog

attach file gives false disk address path as 'C:/fakepath/filename'

After an hour googling and understanding the real cause, today I solved the IE 8 configuration related problem of 'fakepath'. Detail description will be given soon, how I find the problem and its solution and debugging. Ref: http://www.google.com/support/forum/p/gmail/thread?tid=35000181d20d2dae&hl=en   http://www.telerik.com/community/forums/aspnet-ajax/upload/ie8-upload-control-shows-quot-c-fakepath-quot.aspx
Read more

Ajmer tour on 18th June '11

Today went at Ajmer, Rajasthan companied by Asim, zuhaib and sameer. Yesterday, Asim called me and asked whether I will go Ajmer or not, as I was previously interested for such kind of tour. I at that time said that I have no problem and affirmed that I was confirm for that tour. So Asim managed our tickets, four tickets. After returning from office, I prepared for the tour. Our cook was absent at that interval, so cooked alone and took my dinner. After performing Isha namaz, I carried a shirt and a cotton pant, and went for Nizamuddin with Zuhaib by auto rickshaw. There at Nizamuddin, Asim waited for us at the Bus stand. But, only we three were present there, the other one was absent at that time and confirmed that the fourth person will not be available. So we called Sameer to join us. He was just returned from Meerut at that time. After requesting a lot, he agreed for joining us. He catched us at next stop of our bus (I cant remember that place, may be at Madrasa-Masjid near Dariya ...
Read more

How to fix World-writable config file /etc/my.cnf is ignored?

The default configuration file of MySql is my.cnf (location: /etc/my.cnf for Linux) and my.cfg (location: Program File/MySql for windows). For utf-8 supported database, there must be an entry of UTF-8 parameter in my.cfg file. But sometime mysql does use the my.cnf file from other location than /etc/my.cnf. If you change the required parameter in /etc/my.cnf file, it may not be reflected in database. An error: 'World-writable config file /etc/my.cnf is ignored ' will come while executing the mysqld demon. Just change its permission . $ chmod 644 /e tc/my.cnf  and execute  the mysqld demon. $ mysqld  start Ref: http://hecode.com/how-to-fix-world-writable-config-file-etcmy-cnf-is-ignored/ http://dev.mysql.com/doc/refman/5.1/en/linux-installation-rpm.html
Read more