Command line start MySQL service

NET commands have been learned in the computer network course and can be used to start a background service. In MySQL, net commands are used to start the background server process mysqld, which is the background service.

However, if the net start MySQL in normal user mode is unable to start the MySQL service, the situation is as shown.

Normal User mode failed to start MySQL service

Why is this? The reason is that the background service is a relatively high security level, only the administrator has the ability to start the background service, so the normal user mode to start the MySQL service is not successful, and in Administrator mode can be successful. In administrator mode, start the MySQL service as shown in.

Administrator mode starts MySQL service successfully

Summarize:

1) The background service must be turned on in administrator mode. Of course you don't have to say the command line.

2) Start the service with net start service_name; Shut down service with net stop service_name.

Command line start MySQL service