How to Find the Status of MySQL Server


Find the status of MySQL server



There are several possible ways to check the staus of MySQL server.

You need to execute the below commands from bin directory of MySQL installation.

On Linux / Windows

mysqladmin -u root -p Status

Enter password: *******
Uptime: 154500  Threads: 3  Questions: 205  Slow queries: 0  Opens: 131  Flush tables: 1  Open tables: 118  Queries per second avg: 0.001


mysqladmin -u root -p ping

Enter password: *******
mysqld is alive


On Linux only

service mysqld Status

On Windows only

Check the MySQL service Status.



No comments:

Post a Comment