MySQL Service accidental stop 1067 Error resolution summary _mysql

Event Type: Error

Event Source: Service Control Manager

Event Type:
No
Event id:7034

Date: 2012-11-1

Event: 9:25:52
Users: 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.

Then look at the application error and see

Found a hint.

D:xxxxmysqld:shutdown Complete

Now in the computer run to enter Services.msc to find MySQL, this is not the start of the country, we click on the start, there are errors that the MySQL 1067 can not start

Baidu verified that the My.ini configuration has problems, and then we my-large.ini in MySQL modified into My.ini restart, successful.
So when you modify the Mysql.ini, be sure to pay attention to backup.

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

In fact we in order to install, has the MySQL low privileges to run, so here first to Windows to modify user password

My Computer > Right > Admin > Local Users and group > on the MySQL run user (typically mysqladmin) modify the password (and remember).

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




Third: The process unexpectedly terminated after the installation of the problem, if the original installed MySQL please backup the database, complete deletion of the directory, MSSQL is also, or easy to appear problems

Yesterday found that the start of the MySQL problem (such as the title), in the online search for a half-day, there is no solution, found online to say that the solution is

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

This morning finally found the problem of the original, it was my own past inadvertently caused. Before you reload MySQL, you want to put the data folder

The contents are preserved, and the results are directly covered. Causes a 1067 error to occur.

So, the data folder after the backup delete, and then repair the installation, you can!!!