Home >Database >Mysql Tutorial >What to do if mysql server is invalid

What to do if mysql server is invalid

coldplay.xixi
coldplay.xixiOriginal
2020-10-09 11:46:095984browse

Solution to invalid mysql server: 1. Press "windows key R" to open the run dialog box, enter the command "cmd", and press Enter to open the DOS window; 2. Enter "del c:windowstemp*.* / s /q", wait until the file is deleted, and MySQL will naturally return to normal.

What to do if mysql server is invalid

Solution to invalid mysql server:

1.

1. If you encounter this problem, do not reinstall the MySQL database first. The solution is to clear the cache directory of WIndows.

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

3. Enter "del c:windowstemp*.* /s /q" and wait for the file to be deleted. MySQL will naturally return to normal.

Second, configuration file configuration error (solution to mysql startup error 1067)

Issue 1

Delete %windows% /my.ini Delete my.ini elsewhere. Copy my-small.ini to my.ini in the mysql installation directory. Insert the last line of my.ini

: CODE: [mysqld] #Set basedir to point to 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-win32 in>net start mysql MySQL

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

System error 1067 occurred. The process terminated unexpectedly.

 C:mysql-5.1.11-beta-win32 in>mysqld-nt --remove Service successfully removed.

 C:mysql-5.1.11-beta-win32 in> mysqld-nt --install Service successfully installed.

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

Question 2

After installing Mysql, I restarted the computer and found that the service could not be started for the second time. The prompt is as follows:

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

The MySQL service cannot be started.

system error.

System error 1067 occurred.

The process terminated unexpectedly.

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

I checked the error log in the directory F:ProgramDataMySQLMySQL Server 5.5data and the following content is displayed:

 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 prompt is this sentence, the temporary file cannot be created:

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

So check my.ini

 Add to the [mysqld] section:

 #The temporary file directory specified by yourself

 tmpdir="Temporary directory"

Related free learning recommendations: mysql database (video)

The above is the detailed content of What to do if mysql server is invalid. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn