Mysql service unexpectedly stops 1067 error solution summary _ MySQL

Mysql service unexpectedly stops 1067 error solution summary bitsCN.com

Event Type: Error

Event Source: Service Control Manager

Event Type:
None
Event ID: 7034

Date: 2012-11-1

Event: 9:25:52
User: N/

Computer: SVCTAG-HZWGF3X
Description:
The service MySQL stops unexpectedly. This occurs once.

For more information, see help and support center in http://go.microsoft.com/fwlink/events.asp.

Let's look at the application errors.

I found such a prompt

D: xxxxmysqld: Shutdown complete

Enter services. msc on the computer to find mysql. if the mysql is not started, click Start. an error occurs, indicating that mysql 1067 cannot be started.

After Baidu verified that there is a problem with my. ini configuration, and then we modified the my-large.ini in mysql to my. ini restart, succeeded.
Therefore, you must pay attention to the backup when modifying mysql. ini.

2. for the machine we configured, mysql needs to reset the password. Generally, the mysql service may fail to be started after restart.

In fact, we have run mysql with low permissions for installation, so here we first go to windows to change the user password

My computer> right-click> Manage> Local Users and Groups> change the password (and remember) on the mysql running user (usually mysqladmin ).

Then choose start> Run> services. msc (enter service manager)> find mysql
Mysql> right-click> Properties> login> this account
Enter the password you just set.




III. problems may occur after the process unexpectedly terminates the installation. if you have installed mysql, back up the database and delete the directory completely. The same is true for mssql. otherwise, problems may occur easily.

I found a problem (such as a problem) when I started MySQL yesterday. I searched the internet for a long time and found that all the solutions I mentioned on the Internet were not solved.

It's a blind try. Ah, it's a waste of more than n times !!!

This morning, I finally discovered the problem. it turned out that I had accidentally caused it. When I reinstall MySQL, I want to put the Data folder

And the result is overwritten. The error 1067 is returned.

Therefore, you can back up the Data folder and delete it. then, fix and install it !!!

BitsCN.com