MySQL Service unexpected stop 1067 error resolution summary

Today when you configure the server to install mysql5.5 always cannot install, view Log error prompt is 1067 error, see my workaround below

Event Type: Error

Event Source: Service Control Manager

Event Type:
No
Event id:7034

Date: 2012-11-1

Event: 9:25:52
User: N/A

Computer: svctag-hzwgf3x
Describe:
Service MySQL stopped unexpectedly. This happened 1 times.

For more information, see the Help and Support Center in http://go.microsoft.com/fwlink/events.asp.

Look at the application error and see

Found a hint.

D:xxxxmysqld:shutdown Complete

Now in the computer running input services.msc found MySQL, this is not the start country, we click Start, error message that MySQL 1067 cannot start

Baidu after verifying that the My.ini configuration has a problem, and then we MySQL in the My-large.ini modified to My.ini restart, success.
So when you change the Mysql.ini, be sure to pay attention to the backup.

2, after our configuration of the machine, MySQL needs to reset the password, the general restart after the easy access to the MySQL service, unable to start the situation.

In fact, in order to install, we have MySQL low-privilege run, so here first to Windows inside to modify the user password

My Computer > right-click > Admin > Local Users and Groups > Modify the password (and remember) on the MySQL run user (typically Mysqladmin).

Then start > Run > Services.msc (go to Service Manager) > Find MySQL
MySQL > Right-click > Properties > Login > This account
Enter the password you just set.




Three: The process unexpectedly terminates the installation after the problem, if the original installed MySQL please backup the database, completely delete the directory, MSSQL is also, or prone to problems

Yesterday found that the start of MySQL problems (such as the problem), search on the internet for half a day, are not resolved, found that the solution on the Internet is

is blind to try, hey, wasted n more time Ah!!!

This morning finally found the problem, it is my own past inadvertently caused. Before reloading MySQL, you want to put the data folder

Content is retained and the results are directly covered. Causes a 1067 error to occur.

Therefore, the data folder after the deletion, and then repair the installation, you can!!!

MySQL Service unexpected stop 1067 error resolution summary