How to start and stop MySql in Windows

MySQL is more fun, that is, it can be started in multiple ways, of course, it can also be disabled in multiple ways. The following is a simple introduction to several MySQL startup methods. I hope you can provide some reference.

First, start with mysqld-nt.

It is most convenient to start the service in this way when no service is installed. In the console, switch the path to the bin package of MySQL and enter the command start mysqld-NT (of course, you can also start it with the command mysql-nt, but I do not recommend this ), in this way, the service is started (for example ).

Second, it is started as a Windows service.

Of course, when starting in this way, you must first confirm that the MySQL service has been installed on your machine. So let's first introduce the installation of MySQL service. Run cmd to switch the path to: C:/program files/MySQL Server 6.0/bin, enter the command mysqld-NT -- install, if the installation is successful, the system prompts "service successfully installed" (for example ).

After the installation is complete, go to "Control Panel"> "Management Tools"> "services" and you will find one more service, MySQL. Then you can start MySQL through it. Of course, after the service is installed, you can use the command line Net start MySQL to start MySQL (as shown in ).

In addition, there are several stop methods: 1. net stop MySQL (in this case, the service is installed ); 2. mysqladmin-u root Shutdown (when the password is set, the command is mysqladmin-u root-P shutdown );

3. Start Windows through a service program (this is the most intuitive ).