Checking MySQL Server State Using Windows Command Prompt

Posted on by

It’s easy to check whether your installed RDBMS MySQL on your computer is currently running or not. If you don’t have any GUI to show your MySQL server service status, then the command prompt is the fastest replacement tool.

How? Start up the command prompt and type:

netstat -an

The default value of MySQL server service is listening to TCP/IP port 3306. Then look for:

0.0.0.0:3306 ... LISTENING

from the output of the command above. If you see a similiar line, then your MySQL server is currently online and ready to accept requests. If you don’t see it, then probably it has not been started yet. If you had installed it as a Windows service. Start the service with:

net start mysql

Please be noted that mysql is the default service name when you install MySQL server.