MySQL startup "Invalid service name" and "System error 1607" solution under Windows

1. Invalid service name

Input net start MySQL, error "Invalid service name"

Solve:

Go to the MySQL-installed bin directory, such as "C:\Program Files (x86) \mysql\mysql Server 5.6\bin"

Execute command: Mysqld-install install MySQL Service

2. System Error 1607

Input net start MySQL, error "System error 1607"

Solve:

A, >bin execute mysqladmin-u root-p shutdown, and then re-execute the net start MySQL

b, if the above method is invalid, the following method may be feasible

Copy the My-default.ini file under MySQL directory and rename it to My.ini

Will

# Basedir = ...
# DataDir = ...

field, modify it to the actual directory, for example

Basedir = C:\Program Files (x86) \mysql\mysql Server 5.6
DataDir = C:\Program Files (x86) \mysql\mysql Server 5.6\data

Delete MySQL service mysqld-remove

Reinstall Mysqld-install

Execute net start MySQL

MySQL startup "Invalid service name" and "System error 1607" solution under Windows