Resolving the MySQL service failed to boot system 1058 error occurred

Phenomenon: MySQL service failed to start, system 1058 error occurred

My MySQL was originally installed, then the service was banned, and then started with Mysqld-nt standalone, now I want to restart the service, but can not 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