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').