Case: A 1058 error occurred when the MySQL service could not start the system.

Symptom: the mysql service cannot be started and the system has a 1058 error.

After I installed mysql, I used 360 security guard to disable the service and then started it with mysqld-nt standalone. Now I want


New, but cannot start.


Solution:


◆ 1. Run

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

Service successfully removed.


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

Service successfully installed.


D: \ mysql \ bin> net start mysql

MySQL service is starting.

The MySQL service has been started successfully.



◆ 2. Check whether my. ini or my. cnf is normal?

Try to change % 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 my. ini and my. cnf to the System Disk XX: \ WINDOWS \ system32. Check whether the paths in the configuration environment are consistent.