Mysql Startup service 1058 Error resolution _MYSQL

Today research a framework, database using MySQL, start the MySQL service when the 1058 error, the following figure.


Looking for a long time on the internet is the same solution, tried it all not good (only for my local service startup problem is not valid). Online solutions are as follows:

New start, but cannot start.

Workaround:

1, Operation
D:\mysql\bin>mysqld-nt-remove

Service successfully removed.

D:\mysql\bin>mysqld-nt-install

Service successfully installed.

D:\mysql\bin>net start MySQL

The MySQL service is starting.

The MySQL service has started successfully.

2, check My.ini or my.cnf is normal?

Try changing the%systemroot%\my.ini to this.

[Mysqld]

Basedir=d:/mysql

Datadir=d:/mysql/data

default-character-set= GBK

[Winmysqladmin]

Server=d:/mysql/bin/mysqld-nt.exe

3. Copy the My.ini and MY.CNF to the system disk Xx:\windows\system32, and note that some of the paths in the configuration environment are consistent.

Then you can only find out for yourself, now that you are prompted for an error message: The reason may be that the device you have disabled or associated with is not started. See this on the Properties page of the service:


It turned out that the last time the configuration service was disabled.

Start the service. It is best to reboot the machine, otherwise the MySQL service is started, which may disable the service and so on a series of problems.

Well, this is my problem and solution, I hope to be useful to everyone.