[CentOS] mysqld status discrepancy

Tue Jan 25 17:31:40 UTC 2011
Jerry Franz <jfranz at freerun.com>

On 01/25/2011 09:19 AM, ken wrote:
> Bug, explainable, or expected??  Checking the status of mysqld as root,
> then as a regular user:
> # /etc/init.d/mysqld status
> mysqld (pid 4806) is running...
> $ /etc/init.d/mysqld status
> mysqld dead but subsys locked

As expected. The PID file for MySQL is not normally world readable and 
therefore the script cannot determine the PID to check if it is alive if 
run as an regular user (other than as the 'mysql' user or 'root').

Benjamin Franz