MySQL Service 1067 error multiple solutions

The

My.ini in the MySQL directory, and then copies a my.ini on the colleague's machine to modify it and put it in a separate place as a backup. The contents are as follows:
 

The code is as follows

Copy Code

#Uncomment or ADD only the keys, you know. #Read the MySQL Manual for instructions [Mysqld] basedir=d:/mysql5.0/ #bind-address=127.0.0.1 Datadir=d:/mysql5.0/data #language =d:/usr/local/mysql/share/your Language Directory #slow Query log#= #tmpdir #= #port =3306 #set-variable=key_buffer=16m [Winmysqladmin] Server=d:/mysql5.0/bin/mysqld-nt.exe User=root password= And then in the bin directory Mysqld-nt-remove Mysqld-nt-install net start MySQL Ok!

It seems that the most crucial problem is the My.ini.

I saw the MySQL service, the service My.ini boot path has been set up, is under the installation directory, do not need to go to the Windows directory. Helpless in search engine results, the basic is reproduced (said the good call reproduced, not good call collection, more difficult to hear plagiarism). After a lot of turnover, finally found a different. The following are the solutions:

Modify the My.ini

The code is as follows	Copy Code
# The default storage engine that would be used when create new tables Default-storage-engine=innodb Modify "INNODB" to "MYISAM" as: Default-storage-engine=myisam

The main reason is that the version used is not supported for InnoDB.

Other methods of reference

After installation MYSQL5, found that the boot error, and sometimes started normally, but the addition of the immediately error.
Error code: 1067
The solution is as follows:
1. Delete%windows%/my.ini
2. Remove My.ini from other places
3. Copy the My-small.ini to My.ini under the MySQL installation directory
4. Insert on My.ini last line:
[Mysqld]
#设置basedir指向mysql的安装路径

The code is as follows	Copy Code
Basedir=c:mysql-5.1.11-beta-win32 Datadir=c:mysql-5.1.11-beta-win32data

5. Reboot ...

The code is as follows	Copy Code
C:mysql-5.1.11-beta-win32bin>net start MySQL

The MySQL service is starting.
The MySQL service failed to start.
System error.
A system error 1067 occurred.
The process terminated unexpectedly.

The code is as follows	Copy Code
C:mysql-5.1.11-beta-win32bin>mysqld-nt--remove Service successfully removed. C:mysql-5.1.11-beta-win32bin>mysqld-nt--install Service successfully installed. C:mysql-5.1.11-beta-win32bin>net start MySQL

The MySQL service is starting.
The MySQL service has started successfully.

The code is as follows	Copy Code
C:mysql-5.1.11-beta-win32bin>net stop MySQL

The MySQL service is stopping.
The MySQL service has stopped successfully.

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.

Locate the My.ini file in the Windows directory, if you do not copy My-medium.ini from the MySQL installation directory to the C:windowsmy.ini restart service

a way to reinstall

Add in My.ini file in MySQL's home directory

The code is as follows	Copy Code
[Winmysqlserver] Server=c:program Filesmysqlmysql Server 5.0binmysqld-nt.exe CMD run: C:Program filesmysqlmysql Server 5.0binmysqld-nt.exe Remove C:Program filesmysqlmysql Server 5.0binmysqld-nt.exe Install NET MySQL start

parameter is caused by encoding

Adjusting the character set of the server can cause 1067 errors

1067 errors can occur in the following situations:

1. Set up the character set of the server the character set of the Change (my.ini) server

2. After setting the character set of the server, use MySQLWorkbench.exe to change the character set of the server in administration

How to solve this problem?

Use

The code is as follows	Copy Code
%mysqlinstallpath%bin/mysqlinstanceconfig.exe

To change the character set, and then reboot, and use the above program to change the character set as much as possible in the future.

The above described a lot of MySQL service 1067 error solution, I think your problem will be well resolved.