How To: Find Iut If MySQL Is Running On Linux Or Not
Q. How do I find out if my MySQL server is running or not under Linux / UNIX operating systems?
A. You can use mysql startup script or mysqladmin command to find out if it is running on Linux. Then you can use ps command and telnet command too (it is not reliable but it works.). mysqladmin is a utility for performing administrative operations. You can also use shell script to monitor MySQL server. You can use mysqladmin as follows:
# mysqladmin -u root -p status
Output:
Enter password: Uptime: 4 Threads: 1 Questions: 62 Slow queries: 0 Opens: 51 Flush tables: 1 Open tables: 45 Queries per second avg: 15.500
If MySQL serer is running it will display output as above. It displays uptime and number of queries etc. If server is not running then it will dump error as follows
# mysqladmin -u root -p status
Output:
mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Under Debian Linux you can type following command to find out if MySQL server is running or not
# /etc/init.d/mysql statusOutput:
/usr/bin/mysqladmin Ver 8.41 Distrib 4.1.15, for pc-linux-gnu on i486 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.1.15-Debian_1-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 4 min 16 sec Threads: 1 Questions: 66 Slow queries: 0 Opens: 51 Flush tables: 1 Open tables: 45 Queries per second avg: 0.258
If you are using RedHat of Fedora then you can use following script"
# service mysqld statusOR# /etc/init.d/mysqld statusSee also:
E-mail this to a friend
Printable version
Related Other Helpful FAQs:
- Linux / UNIX: Find out or determine if process pid is running
- Securing MySQL server
- How do I access MySQL server from the shell prompt (command line)?
- Your PHP installation appears to be missing the MySQL extension which is required by WordPress
- MySQL startup script under BSD/Linux
Discussion on This FAQ
Leave a Reply
We encourage your comments, and suggestions. But please stay on topic, be polite, and avoid spam. Thank you very much for stopping by our site!
Tags: check if mysql is running, check if mysql is running linux, check if mysql running, check mysql running, check that mysqld is running and that the socket, checking if mysql is running in linux, how to check if mysql is running, how to check mysql running linux, how to determine if mysql is running, linux check if mysqld is running
January 15th, 2007 at 11:32 am
Also we can use
mysqladmin -umysql ping
It says “mysqld is alive” if mysql is running o/w
prints some messages.
If it doesn’t work then try:
mysqladmin -uDB_USERNAME -pDB_USERPASSWORD ping
Where you have to replace DB_USERNAME and DB_USERPASSWORD with actual values.
Thanks & Regards,
Yashpal