Windows Server MySQL startup failure how to do

One, correct configuration file, clear cache

1. In the face of this problem, do not rush to reinstall the MySQL database, in fact, the solution is very simple, people need to clean up the Windows cache directory on it.
2. Press "Windows key +r" to open the Run dialog box, enter the command "CMD", return to open the DOS window.

3. Enter "del c:\windows\temp\*.*/s/q", waiting for files to be deleted, MySQL will naturally return to normal.

Second, configuration file configuration error (MySQL startup error 1067 resolution)

Question one

Delete%windows%/my.ini Delete the My.ini in the MySQL installation directory to copy My-small.ini to My.ini in My.ini

Last line insert: CODE: [Mysqld] #设置basedir指向mysql的安装路径

Basedir=c:mysql-5.1.11-beta-win32 Datadir=c:mysql-5.1.11-beta-win32data

Reboot ...

c:mysql-5.1.11-beta-win32in>net start MySQL MySQL

The service is starting. The MySQL service failed to start. System error.

A system error 1067 occurred. The process terminated unexpectedly.

C:mysql-5.1.11-beta-win32in>mysqld-nt--remove Service successfully removed.
C:mysql-5.1.11-beta-win32in>mysqld-nt--install Service successfully installed.
c:mysql-5.1.11-beta-win32in>net start MySQL MySQL service is starting. The MySQL service has started successfully. c:mysql-5.1.11-beta-win32in>net stop MySQL MySQL service is stopping. The MySQL service has stopped successfully.

Question Two

After MySQL installed, restart the computer The second Discovery service failed to start. The prompts are as follows:

------------------------

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

------------------

Viewed the error log in the directory F:programdatamysqlmysql Server 5.5data, which shows the following:

130825 20:47:50 [note] Plugin ' federated ' is disabled.
130825 20:47:50 innodb:the InnoDB memory heap is disabled
130825 20:47:50 innodb:mutexes and rw_locks use Windows interlocked functions
130825 20:47:50 innodb:compressed tables use zlib 1.2.3
130825 20:47:50 InnoDB:Error:unable to create temporary file; Errno:2
130825 20:47:50 [ERROR] Plugin ' InnoDB ' init function returned ERROR.
130825 20:47:50 [ERROR] Plugin ' InnoDB ' registration as a STORAGE ENGINE.
130825 20:47:50 [ERROR] unknown/unsupported storage Engine:innodb
130825 20:47:50 [ERROR] Aborting

One of the core hints is that the temporary file cannot be created:

130825 20:47:50 InnoDB:Error:unable to create temporary file; Errno:2

So view My.ini

[Mysqld] section joined:
#自己指定的临时文件目录
Tmpdir= "Temp directory"