Mysql service 1067 error multiple solutions _ MySQL

Mysql service 1067 error multiple solutions share bitsCN. commy. ini in the MySQL directory, so I copied a my. ini file on my colleague's machine and put it in a separate place as a backup. The content is as follows:

# Uncomment or Add only the keys that you know how works.
# 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 = 16 M
[WinMySQLadmin]
Server = d:/MySQL5.0/bin/mysqld-nt.exe
User = root
Password =
Then, in the bin directory
Mysqld-nt-remove
Mysqld-nt-install
Net start mysql
OK!

The most critical issue is my. ini.
I have read the MySQL service, and the startup path of the service my. ini has been set up long ago. it is in the installation directory and does not need to be in the windows directory. What is helpless is that the results searched by the search engine are basically reprinted (reprinted is good, not good is collection, not good is plagiarism ). After several turns, I finally found a different one. The solution is as follows:
Modifying my. ini

# The default storage engine that will be used when create new tables when
Default-storage-engine = INNODB
Change "INNODB" MYISAM ":
Default-storage-engine = MYISAM

This is mainly because the version used does not support INNODB.

Other reference methods

After MYSQL5 is installed, startup error is found. sometimes startup is normal, but an error occurs immediately after the connection is added.
Error Code: 1067
The solution is as follows:
1. delete % windows %/my. ini
2. delete my. ini from other locations
3. copy the my-small.ini to my. ini under the mysql installation directory
4. insert in the last line of my. ini:
[Mysqld]
# Set basedir to the mysql installation path

Basedir = C:/mysql-5.1.11-beta-win32
Datadir = C:/mysql-5.1.11-beta-win32data

5. restart...

C:/mysql-5.1.11-beta-win32bin> net start mysql

MySQL service is starting.
The MySQL service cannot be started.
System error.
System error 1067 occurs.
The process stops unexpectedly.

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

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

C:/mysql-5.1.11-beta-win32bin> net stop mysql

MySQL service is stopping ..
The MySQL service has been stopped successfully.
Solution 1: Copy the my-***. inf file in the mysql directory to the windows directory of the system. Change the file name to my. inf.
Then add similar code in the [mysqld] code area:

# Set basedir to installation path, e.g., c:/mysql
# Set it to the 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 it to the MYSQL data directory
Datadir = D:/Program Files/mysql-5.0.45-win32/data

Solution 2: mysql 1067
The error is as follows:
1. run winmysqladmin to generate the my. ini file.
2. start mysql service with mysqld-install
3. net start mysql startup mysql service display normal
When the mysql-u root-p connection is used, an error indicating that the server has not been started is reported. check the server service. it is true that the mysql service has not been started. if the mysql service is manually started, a 1067 error is generated and the mysql service has been re-installed several times, the error persists. Check that all configurations are correct.
My system environment is win2003 mysql 4.0.12.
Solution: copy my. ini generated by winmysqladmin to c: windows and start mysql.

Find the my. ini file in the Windows directory, and restart the service if the my-medium.ini in the mysql installation directory is not copied to c: windowsmy. ini.

A reinstallation method
Add

[WinMySQLServer]
Server = c: Program FilesMySQLMySQL Server 5.0binmysqld-nt.exe
Run the following command in CMD:
C: Program FilesMySQLMySQL Server 5.0binmysqld-nt.exe remove
C: Program FilesMySQLMySQL Server 5.0binmysqld-nt.exe install
Net mysql start

The parameter is encoded.

Adjusting the server's character set will cause 1067 errors.
Error 1067 may occur in the following cases:
1. set the character set of the server and change the character set of the my. ini server
2.set the Server's character set and use mysqlworkbench.exe to change the Server's character set in Server Administration
How can this problem be solved?
Use

% MySQLInstallPath % bin/MySQLInstanceConfig.exe

To change the character set, and then restart. in future use, try to use the above program to change the character set.
I have introduced a lot of solutions for mysql 1067 errors. I think your problem will be well solved. BitsCN.com