MySQL in Windows net start mysql Start MySQL service error occurs System error solution

MySQL in Windows net start mysql Start MySQL service error occurs System error solution

1- Error details

Run net start mysql in cmd to start the MySQL service: a system error 5 is displayed. access denied.

Running in cmd administrator mode can start the MySQL service

insert image description here

2-Single Solution

2.1-Directory C:\Windows\System32 -> find cmd.exe

insert image description here

2.2- Right click Properties -> Run as Administrator

insert image description here

2.3-Run successfully

insert image description here

3- Permanent solution

3.1-In 2.2: Right-click Properties -> Send to (N) -> Desktop Shortcut

insert image description here

3.2- Right click Properties -> Shortcut -> Advanced -> Run as Administrator -> OK

In the future, just open the shortcut and run cmd as an administrator!

insert image description here

3.3-Run successfully:

insert image description here

4- Notes

4.1-Windows service names are not case sensitive

insert image description here

4.2- Meaning of the two statements

# Start the service in Windows net start + service name # Close the service in Windows net stop + service name

For example:

# Start the service named mysql57 in Windows net start mysql57
# Shut down the service named mysql57 in Windows.
net stop mysql57

This is the end of this article about the solution to the system error when starting the MySQL service with net start mysql in Windows. For more information about the system error when starting the MySQL service with net start mysql, please search 123WORDPRESS.COM's previous articles or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!

You may also be interested in:
  • Detailed explanation of the installation, configuration, startup and shutdown methods of the Mysql server
  • MySQL multi-instance installation boot auto-start service configuration process
  • MySQL5.7 single instance self-starting service configuration process
  • MySQL configuration master-slave server (one master and multiple slaves)
  • 5 MySQL GUI tools recommended to help you with database management
  • 19 MySQL optimization methods in database management
  • Detailed introduction to 5 commonly used MySQL database management tools
  • Summary of Common Commands for MySQL Database Management
  • MySQL service and database management

<<:  Detailed steps to install the specified version of docker (1.12.6) using rpm

>>:  In-depth understanding of the vertical-align property and baseline issues in CSS

Recommend

Native js custom right-click menu

This article example shares the specific code of ...

mysql 5.7.19 latest binary installation

First download the zip archive version from the o...

Detailed explanation of nodejs built-in modules

Table of contents Overview 1. Path module 2. Unti...

Mini Program to Implement Sieve Lottery

This article example shares the specific code of ...

mysql5.7.18 decompressed version to start mysql service

The decompressed version of mysql5.7.18 starts th...

js realizes the function of clicking to switch cards

This article example shares the specific code of ...

How to use selenium+testng to realize web automation in docker

Preface After a long time of reading various mate...

Don't forget to close the HTML tag

Building web pages that comply with Web standards ...

Three ways to jump to a page by clicking a button tag in HTML

Method 1: Using the onclick event <input type=...

Steps to build MHA architecture deployment in MySQL

Table of contents MAH 1. Introduction to MAH Arch...

Introduction to Common XHTML Tags

<br />For some time, I found that many peopl...