Quick Start of mysql, simple batch processing command _ MySQL

Quick start to mysql. it is very troublesome to manually open the database when using mysql through simple batch processing commands. I found a method on the Internet and tried it. it is very useful!

1. create a notepad (txt) and enter the following content.

@ Echo off


For/f "skip = 3 tokens = 4" % I in ('SC query mysql') do set "zt = % I" & goto: next





: Next


If/I "% zt %" = "RUNNING "(


Echo has found that the service is running and the service is being closed


Net stop mysql


) Else (


Echo the service is now in the stopped processing status and is now enabling the service


Net start mysql


)

Exit

2. Save the txt file and change the suffix to. bat. Done.

In the future, do not manually enter the command. double-click the batch processing file (. bat) you just made and start the MYSQL service directly. I learned and moved it.