Linux Archive - mysqld status discrepancy

Linux Archive (http://www.linux-archive.org/)

- CentOS (http://www.linux-archive.org/centos/)

- - mysqld status discrepancy (http://www.linux-archive.org/centos/480989-mysqld-status-discrepancy.html)

mysqld status discrepancy

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

_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos

mysqld status discrepancy

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
_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos