Mysql Startup service 1058 Error resolution _MYSQL
Source: Internet
Author: User
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.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.