My.ini in the MySQL directory, and then copied a my.ini on a colleague's machine to modify it and put it in a separate place as a backup. Its contents are as follows:
Copy Code code as follows:
#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
Copy Code code as follows:
# 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的安装路径
Copy Code code as follows:
Basedir=c:\mysql-5.1.11-beta-win32
Datadir=c:\mysql-5.1.11-beta-win32data
5. Reboot ...
Copy Code code as follows:
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.
Copy Code code as follows:
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.
Copy Code code as follows:
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:
Copy Code code as follows:
# 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
Copy Code code as follows:
[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
Copy Code code as follows:
%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 recent cloud-Habitat community technology to do security, will be running MySQL low privileges, there are problems, the original is because the first to do security causes permissions do not inherit. Finally, the MySQL permissions added to the OK.
The above described a lot of MySQL service 1067 error solution, I think your problem will be well resolved.
