Windows Server MySQL startup failure

1. The configuration file is correct and the cache is cleared.

1. if you encounter this problem, do not rush to reinstall the MySQL database. In fact, the solution is very simple. You need to clear the WIndows cache directory.

2. Press "windows key + R" to open the running dialog box, enter the command "cmd", and press enter to open the DOS window.

3. Enter "del c: windowstemp *. */s/q". After the file is deleted, MySQL will naturally return to normal.

2. configuration file configuration error (mysql startup error 1067)

Question 1

Delete % windows %/my. ini delete my. ini elsewhere copy the my-small.ini TO my. ini in my. ini under the mysql installation directory

Insert the last line: CODE: [mysqld] # Set basedir to point to the mysql installation path

Basedir = C: mysql-5.1.11-beta-win32 datadir = C: mysql-5.1.11-beta-win32data

Restart...

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

The service is starting. MySQL service cannot be started. System error.

System Error 1067 occurs. The process stops 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. MySQL service has started successfully. C: mysql-5.1.11-beta-win32in> net stop mysql MySQL service is stopping .. MySQL service has stopped successfully.

Question 2

After Mysql is installed, restart the computer and find that the service cannot be started for the second time. The prompt is as follows:

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

The MySQL service cannot be started.

System error.

System Error 1067 occurs.

The process stops unexpectedly.

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

The error log in the directory F: ProgramDataMySQLMySQL Server 5.5 data is displayed as follows:

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' registry as a storage engine failed.

130825 20:47:50 [ERROR] Unknown/unsupported storage engine: INNODB

130825 20:47:50 [ERROR] Aborting

The core prompt is this, and temporary files cannot be created:

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

View my. ini

Add the following content to the [mysqld] section:

# Self-specified temporary file directory

Tmpdir = "temporary directory"