Shulou(Shulou.com)06/01 Report--

Editor to share with you the solution to the invalid mysql server, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Mysql server invalid solutions: 1, press the "cmd key + R" to open the run dialog box, enter the command "cmd", enter the DOS window; 2, enter "windowstempacks. * / s / Q", wait for the file to be deleted, MySQL will naturally return to normal.

Solution to invalid mysql server:

I.

1. Do not reinstall the MySQL database when you encounter this problem. The solution needs to clean up the cache directory of WIndows.

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

3. Enter "del CWR windowstempacks. * / s / Q", wait for the file to be deleted, and MySQL will naturally return to normal.

Second, configuration file misconfiguration (resolution of mysql startup error 1067)

Question one

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

The last line is inserted: CODE: [mysqld] # set the installation path where basedir points to mysql

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. The MySQL service could not be started. 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.

The C:mysql-5.1.11-beta-win32in > net start mysql MySQL service is starting. The MySQL service has started successfully. The C:mysql-5.1.11-beta-win32in > net stop mysql MySQL service is stopping.. The MySQL service stopped successfully.

Question two

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

The MySQL service could not be started.

System error.

A system error 1067 occurred.

The process terminated unexpectedly.

-

Look at the error log in the F:ProgramDataMySQLMySQL Server 5.5data directory and display 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 failed.

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

130825 20:47:50 [ERROR] Aborting

The core hint is that a temporary file cannot be created:

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

So check my.ini.

In the [mysqld] section, add:

# temporary file directory specified by yourself

Tmpdir= "temporary directory"

The above is all the contents of the invalid solution to the mysql server, thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.