mysql service 1067 error multiple solution sharing

my.ini is in the directory of MySQL, so I copied a copy of my.ini on my colleague's machine and modified it, and put it in a separate place as a backup. It reads 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=16M 

[WinMySQLadmin] 

Server=d:/MySQL5.0/bin/mysqld-nt.exe 

user=root 

password= 

 Then, in bin directory  

mysqld-nt -remove 

mysqld-nt -install 

net start mysql 

ok! 

The key problem, it seems, is this
I have seen the MySQL service. The my.ini startup path of the service is already set up in the installation directory, so there is no need to go to the windows directory. Helpless is in the search engine search out of the results, the basic is reproduced (say good to call reproduced, not good to call collection, not good to call plagiarism). After a lot of turnover, I finally found a different one. The solutions are as follows:
The modified my. ini

 

# The default storage engine that will be used when create new tables when 

default-storage-engine=INNODB 

 will "INNODB The modified "MYISAM" To:  

default-storage-engine=MYISAM 

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

Other reference methods

After installing MYSQL5, it was found that there was an error in startup. Sometimes the startup was normal, but it was immediately wrong when adding.
Error code: 1067
The solution is as follows:
1. Delete % windows % / my. ini
2. Delete my.ini elsewhere
3. Copy my-small.ini to my.ini in the mysql installation directory
4. Insert in the last 1 line of my.ini:
[mysqld]
Set basedir to point to the installation path of mysql

 

basedir=C:\mysql-5.1.11-beta-win32 

datadir=C:\mysql-5.1.11-beta-win32data 

5. Reboot...

 

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

The MySQL service is starting.
The MySQL service could not be started.
System error.
System error 1067 occurred.
The process terminated 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 

The MySQL service is starting.
MySQL service started successfully.

 

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

The MySQL service is stopping..
The MySQL service was successfully discontinued.
Solution 1: copy one copy of the my-***.inf file from the mysql directory to the windows directory on 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 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 

Solution 2 mysql 1067
The error is as follows:
1. Execute winmysqladmin and generate my.ini
2. mysqld-install start mysql service
3. net start mysql startup mysql service display is normal
When connecting through mysql-u es1064en-p, the server was reported to be not started. If you check server service, it is true that mysql service was not started. When manually starting mysql service, 1067 error was generated. Check that there are no errors in each configuration.
My system environment win2003 mysql version 4.0.12.
To solve the problem, copy my.ini generated by winmysqladmin to c:windows and start mysql to cut OK.

Find the Windows files in the Windows directory.ini. If you do not copy my-medium. ini from the mysql installation directory as c: windowsmy. ini

One way to reinstall
Add in the my.ini file in the home directory of mysql

 

[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 

Parameters are caused by coding

Tuning the server's character set resulted in a 1067 error
1067 errors occur in the following situations:
1. Change the server's character set (my.ini) after setting the server's character set
2. After setting the server's character set, use MySQLWorkbench.exe to change the server's character set in Server Administration
How to solve this problem?
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

Recently, when this site technology was doing security, mysql was running with low permissions, which also caused some problems. The original reason was that the permissions were not inherited because the security was done first. Finally, add the permissions of mysql to OK.

I think your problem will be solved well with the large number of errors in mysql service 1067 described above.