MySQL database startup failed 1067 solution summary of unexpected termination of process

Problem phenomenon:

The day before yesterday to the MySQL database migration operations, B Machine (new) of the MySQL and a machine version of different, for the convenience of B machine installed MySQL directly copy a machine's data directory

Start MySQL, "MySQL 1067 process accidental termination" error, previously encountered this error, inertia to go to the last method to try to solve the problem, the result is still, so Google, search for a long time ... No fruit

Finally check the System Application log: Find the most recent MySQL error, all e:

The error message file ' D:\system\MySQL\MySQL Server 5.0\share\english\errmsg.sys ' had the only error messages,
But it should contain at least 481 error messages.
Check that the above file was the right version of

Probably a version of the problem

Workaround:

Keep the B-machine migrated database, redo the MySQL installation program on B machine Repair operation, installation completed, restart mysql,ok!

My MySQL ran into 1067 errors.
the error message is: A system error has occurred. System error 1067 has occurred. The process terminated unexpectedly.

The solution on my machine is:

Modify%windir%\my.ini, add [mysqld] #设置basedir指向mysql的安装路径 basedir=d:\program\tools\mysql datadir=d: \program\tools\mysql\data

Unable to start MySQL service error 1067 process terminated unexpectedly

Point to start the MySQL service prompt: The local computer cannot start the MySQL service error 1067 process terminated unexpectedly
This service is the beginning--settings--Control surface version--management tools--services
Workaround one: Copy a my-***.inf file from the MySQL directory to the system's Windows directory. Modify the file name My.inf.

Then add similar code in the [Mysqld] code area:

The code is as follows	Copy Code
# set Basedir to installation path, e.g., c:/mysql # set to MySQL installation directory Basedir=d:/program Files/mysql-5.0.45-win32 # set DataDir to location of data directory, # e.g., C:/mysql/data or D:/mydata/data # set to MySQL data directory Datadir=d:/program Files/mysql-5.0.45-win32/data

Workaround two MySQL 1067

The error is as follows:

1, execute winmysqladmin, generate My.ini file
2, Mysqld-install start the MySQL service
3, net start MySQL start MySQL service display normal
When the Mysql-u root-p connection to the server did not start the error, look at the server service, the MySQL service does not start, the manual start generated 1067 errors, reinstall a few times MySQL, the error remains. See that there are no errors in each configuration.

My system environment win2003 MySQL version 4.0.12.
Solution, will winmysqladmin generated My.ini copy to the c:windows and then start MySQL on all OK.
This has not been tried: in fact, do not need to reconfigure you just click on the/bin directory in turn Mysql.exe

Mysqld.exe

Mysqld-nt.exe

Winmysqladmin.exe

When the prompt box appears, directly cancle off

Then click on the Winmysqladmin.exe on the right side of the small icon to choose to start the service on it

So the INI file is automatically restored.

Workaround Three

1. Error reason: Modified MySQL configuration file My.ini.

2. View error:

Partial code for the My.ini configuration file:

The code is as follows	Copy Code
[Mysqld] port=3306 Basedir= "d:/mysql/" Datadir= "C:/Documents and Settings/all users/application data/mysql/mysql Server 5.1/data/"

3. Solution:

Found the cause of the error, it is relatively easy to solve the error, we only need to double-click MysqlbinMySQLIntanceConfig.exe, reconfigure to solve the problem.