Today I am studying a framework. When the database uses mysql to start the mysql service, the error 1058 is reported, for example.
I tried the same solution after searching for the Internet for a long time. I tried it again and it didn't work (it was not valid only for problems that occurred when I started the local service ). The solution is as follows :,
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.
Later, you can only find the cause by yourself. Since the error message is displayed: The cause may be that the device has been disabled or is not started. On the Service property page, you can see this:
It turns out that this configuration service was disabled unexpectedly last time.
Start the service. It is best to restart the machine. Otherwise, mysql services may be started, and services may not be disabled.
Well, this is my problem and solution, and I hope it will be useful to you.