Unable to start MySQL service Problem resolution Rollup

The MySQL service failed to start on the local computer error 1067 process Unexpected termination this is typically My.ini file configuration error

First find this file: Default installation path

The code is as follows	Copy Code
C:/Program Files/mysql/mysql Server 5.1/my.ini

Open this file to find: Default-storage-engine=innodb is about 84 lines.

Change the value of Default-storage-engine to: MYISAM, this time, the MySQL service can be started.

But there's a problem: because the databases you created before are still there (if not deleted),

Default path:

The code is as follows	Copy Code
C:/Documents and Settings/all users/application data/mysql/mysql Server 5.1/data

This problem may come out at this time:

The first set of Efault-storage-engine is not the same as the value of the second setting, which can cause

1: Found Unable to select Add transaction support Data Engine InnoDB

2: May say does not support INNODB and so on

Workaround:

The code is as follows	Copy Code
Delete: Ib_logfile0 Ib_logfile1 Ibdata1

Restart the service and make the achievement OK again

Resolve failed to start

Common workaround when you encounter a failure to start MySQL:
A, first use the command C:Program filesmysqlbinmysqladmin-u root-p shutdown to close MySQL
B, and then under the cmd command line, execute net start MySQL to start MySQL.

Two, 1067 error common solution

Failure phenomenon
If there is a 1067 error while stopping MySQL (net stop MySQL) or starting MySQL, the error message "MySQL service is stopping ... System error (A Systems error has occurred ...). System error 1067 has occurred., the process terminates unexpectedly (the processes terminated unexpectedly.).

Common Solutions
If you have been running OK before, please follow the "Cannot start" solution above to perform a look.
If you have a remove instance operation, after rebuilding again, be sure to check the My.ini file DataDir has been restored, if the database does not exist under the address, will also report 1067 errors, only need to modify into a real database directory address, and then manually start.

Check MySQL directory permissions

Check to see if there is a Basedir installation directory path and DATADIR database path under the [Mysqld] field in the My.ini file, My.ini may need to appear in two places, MySQL's installation directory and Windows directory (assuming it is a Windows environment), Have to check.

Sometimes delete%windir%/my.ini files and then reconfigure can also be resolved, once again configured to check the windir directory whether there are my.ini files, and sometimes the installation directory under the latest My.ini copies of the past cover can also solve the problem.

If it is a Linux environment, try to copy Mysql.server to/etc/rc.d/init.d/, then run Chkconfig mysql.server, then you can set path on the command line and use the command to perform MySQL boot.

Third, illegal shutdown caused by MySQL can not start the problem

If it is because of illegal shutdown and other reasons MySQL can not start or start a problem, it is best to use the reinstall or confirm that the MySQL data table is OK and ibdata1, Mysql.pid, IB_LOGFILE0, and other documents to cover, the days have encountered many times this situation, is the original MySQL table has a problem, always can not start, but the new table can be changed.

Four, Reload MySQL
When you find a problem with MySQL, the most convenient way is to uninstall the MySQL first, and then reinstall the reconfiguration, specific methods are as follows:
1, uninstall MySQL, clean out the installation directory and Windows directory My.ini files.
2, check the Task Manager whether there is a MySQL process, if there is, you can kill Mysqld.exe, or first kill and then uninstall can also.
3, in the cmd command window, execution: SC delete mysql, the command is the cleaning up Registration Service command.
3. Re-install MySQL
If this problem occurs after the security settings, it may be because the MySQL to run with low privileges because of password policy issues, and so on, we look malicious will MySQL's startup user under the password, and then set in the service item can be.

The MySQL service failed to start on the local computer error 1067 process Unexpected termination this is typically a My.ini file configuration error,

You can delete the My.ini files in the system directory,
Try writing the following back into the My.ini file,
To properly overwrite the file path

My My.ini, December 31, 2007.

code is as follows

copy code

[Winmysqladmin ] Server=c:/mysql/mysql/bin/mysqld-opt.exe user=root [mysqld] Basedir=c:/mysql/mysql DataDir =c:/mysql/mysql/data #bind-address=192.168.0.2 #language =d:/mysql/share/chinese =========================================== [winmysqladmin] Server=d:/mysql/bin/mysqld-opt.exe User=root [mysqld] Basedir=d:/mysql datadir=d:/mysql/data #bind-address=192.168.0.2 #language =d:/mysql/ Share/chinese

============================================
Look for the My.ini file in the Windows directory, edit the content (if there is no file, create a new one), and include at least basedir,datadir two basic configurations.

The code is as follows

Copy Code

[Mysqld] # set Basedir to installation path, e.g., c:/mysql # set to MySQL installation directory Basedir=d:/www/webserver/mysql # set DataDir to location of data directory, # e.g., C:/mysql/data # set to MySQL data directory Datadir=d:/www/webserver/mysql/data Also, be aware that: [Winmysqladmin] Server=d:/www/webserver/mysql/bin/mysqld-nt.exe User=root Password=xxxxxxxx #以上是设置WinMySQLadmin的配置 [Client] User=root Password=xxxxxxxx

To add MySQL to Windows system services:

1., installation Services.

Under Windows2000, after installation, and did not install MySQL into service, we must execute the following statement to register MySQL as a service: Installdirmysqlbinmysqld-nt–-install.

There is no concept of service under WINDOWS98, so no service is installed.

2. Start Service

Under Windows2000, you can start the MySQL service after installing the service: net start MySQL.

Under Windows98, you can start the service with the following command: C:MYSQLBINMYSQLD, the service starts in the background, and there is no interface.

3. Stop Service

Under Windows2000, you can stop the MySQL service by using the following command: net stop MySQL.

Under Windows98, you can stop the service:c:> c:mysqlbinmysqladmin-u root shutdown by following the command