Summary of various solutions that MySQL cannot start or stop

This article summarizes some solutions that MySQL cannot be started or stopped, including in windows and linux. For more information, see.

Unable to start

A. Run the C:/Program files/mysql/bin/mysqladmin-u root-p shutdown command to disable MYSQL.

B. Execute net start mysql to start mysql under the cmd command line.

Tip: Plugin 'innodb' registry as a storage engine failed.
Unknown/unsupported table type: INNODB Error

It turns out that the two versions of MySQL use the INNODB engine that supports transactions by default, open the my. ini file, and in the MySQL installation folder, such as c: program filesMySQL, you can see:

Default-storage-engine = INNODB

The solution is to change this setting

Default-storage-engine = MYISAM

Still use MyISAM as the default database engine, save the my. ini file, start the MySQL service manually, and then close the Configuration window.

Error code: 1067 importing mysql cannot start

The solution is as follows:

1. Delete % windows %/my. ini
2. delete my. ini from other locations
3. Copy the my-small.ini TO my. ini under the mysql installation directory
4. Insert in the last line of my. ini:
[Mysqld]
# Set basedir to the mysql installation path
Basedir = C: mysql-5.1.11-beta-win32
Datadir = C: mysql-5.1.11-beta-win32data
5. Restart...
Mysql-5.1.11-beta-win32bin> net start mysql
MySQL service is starting.
The MySQL service cannot be started.
System error.
System Error 1067 occurs.
The process stops unexpectedly.
C: mysql-5.1.11-beta-win32bin> mysqld-nt -- remove
Service successfully removed.
C: mysql-5.1.11-beta-win32bin> mysqld-nt -- install
Service successfully installed.
Mysql-5.1.11-beta-win32bin> net start mysql
MySQL service is starting.
The MySQL service has been started successfully.
C: mysql-5.1.11-beta-win32bin> net stop mysql
MySQL service is stopping ..
The MySQL service has been stopped successfully.

 
MYSQL cannot be started due to illegal Shutdown

If the MYSQL cannot be started because of an illegal shutdown or other reasons, it is recommended to use the mysql data table that is re-installed or confirmed to be OK and ibdata1, mysql. files such as pid and ib_logfile0 are overwritten. tianyuan has tried many times. This is because the original MYSQL table is faulty and cannot be started, but it can be replaced with a new table.
 
Windows xp operating system

No matter what version of mysql is installed, an error will be reported midway through the mysql service started in the management tool.
Content: unable to start mysql service on local computer error 1067: Process aborted unexpectedly

The solution is as follows:

Find the my. ini file in the system directory (which should be verified later in the windows directory) and edit the content (if this file is not available ).
), Including at least two basic configurations: basedir and datadir.
[Mysqld]
# Set basedir to installation path, e.g., c:/mysql
# Set it to the MYSQL installation directory
Basedir = D:/www/WebServer/MySQL
# Set datadir to location of data directory,
# E.g., c:/mysql/data or d:/mydata/data
# Set it to the MYSQL DATA DIRECTORY
Datadir = D:/www/WebServer/MySQL/data

In addition, you need an idea
[WinMySQLadmin]
Server = D:/www/WebServer/MySQL/bin/mysqld-nt.exe
User = root
Password = xxxxxxxx
# The above is the configuration for setting WinMySQLadmin
[Client]
User = root
Password = xxxxxxxx