1. The configuration file is correct and the cache is cleared. 1. In this case, 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 cmd, and press enter to open the DOS window. 3. Enter delc: windowstemp *. * sq and wait for the file to be deleted.
1. The configuration file is correct and the cache is cleared. 1. In this case, 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 cmd, and press enter to open the DOS window. 3. Enter del c: windowstemp *. */s/q, and wait for the file to be deleted.
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"