After installing the MYSQL5, it is found that the startup error, sometimes starting normally, but the error is immediately added.
Error code: 1067
The solution is as follows:
Delete%windows%/my.ini
Remove My.ini from other places
Copy the My-small.ini to My.ini under the MySQL installation directory
Insert the last line in My.ini:
CODE:
[Mysqld]
#设置basedir指向mysql的安装路径
Basedir=c:\mysql-5.1.11-beta-win32
Datadir=c:\mysql-5.1.11-beta-win32\data
Restart ...
CODE:
C:\mysql-5.1.11-beta-win32\bin>net start MySQL
The MySQL service is starting.
The MySQL service could not be started.
System error.
System error 1067 has occurred.
The process terminated unexpectedly.
C:\mysql-5.1.11-beta-win32\bin>mysqld-nt--remove
Service successfully removed.
C:\mysql-5.1.11-beta-win32\bin>mysqld-nt--install
Service successfully installed.
C:\mysql-5.1.11-beta-win32\bin>net start MySQL
The MySQL service is starting.
The MySQL service has started successfully.
C:\mysql-5.1.11-beta-win32\bin>net stop MySQL
The MySQL service is stopping:
The MySQL service has stopped successfully.
Fix for MySQL startup error 1067