mysql 1067 cannot start

MySQL is a popular open source database management system that is widely used in web applications and websites. However, when using MySQL, you often encounter various error codes, one of the common errors is "MySQL 1067 failed to start".

When you try to start the MySQL service, you may receive the following error message: "Error 1067: Process terminated unexpectedly". This means that the MySQL service cannot start and you cannot connect to the database and execute any queries or commands.

So, why does the MySQL 1067 cannot start error occur? What are the solutions? This article will attempt to answer these questions.

Possible reasons for this error

Before we start to solve the problem, let us understand some of the reasons that may cause the MySQL 1067 cannot start error, which is very helpful for us to locate the problem:

1. Bad my.ini file

The my.ini file contains information about the MySQL instance configuration. If the my.ini file contains invalid configuration or is incorrect, it may cause MySQL failed to start.

2. Port is occupied

The default port number used by MySQL is 3306. If other processes are using the same port, MySQL will fail to start and report an error.

3. Database file damage

The MySQL database file may be damaged, resulting in a situation where MySQL cannot connect to the database and therefore cannot start the service.

4. MySQL service is not installed correctly

Installing the MySQL service is a complicated process. If the MySQL service is not installed or configured correctly, it may cause it to fail to start.

5. MySQL service was not uninstalled correctly

If the MySQL service is not uninstalled correctly, it will cause the previous installation to remain in the system, causing startup errors.

Methods to solve the MySQL 1067 cannot start error

There are the following methods to solve the MySQL 1067 cannot start error:

Method 1: Repair the my.ini file

First, open the my.ini file (in the MySQL installation directory) and check all lines starting with #, they are comment lines and should not cause problems.

Try to comment or delete the following three parameter lines, and then try to restart the MySQL service.

skip-networking

innodb_additional_mem_pool_size=2M

innodb_use_sys_malloc=ON

Method 2: Change the MySQL default port

If you are sure other The process is using port 3306, please change the default port number of MySQL. For example, the default port 3325 can be changed to an alternative port of 3306. Open the my.ini file in an editor and search for "3306" and replace it with the alternative port number like this:

port=3325

Then, try restarting the MySQL service .

Method 3: Check the database file

If the MySQL database file is damaged, the database must be restored. You can use the tools that come with MySQL to try to repair the damaged database file.

First, try executing the following command in the MySQL command prompt:

mysqlcheck.exe -u root -p –all-databases

This will check all MySQL databases and Repair damaged tables.

If repairing the database still does not solve the problem, you may need to reinstall the MySQL service. Before reinstalling MySQL, make sure that the data that needs to be saved has been backed up to other storage devices.

Method 4: Reinstall the MySQL service

If the MySQL service is not installed or configured correctly, it may cause it to fail to start. In this case, you can try reinstalling the MySQL service.

Before reinstalling MySQL, make sure that the previously installed MySQL service has been uninstalled and the previous installation files have been deleted from the computer. If the MySQL service was not uninstalled correctly, you can use the Microsoft Windows Installer Cleanup Utility (https://technet.microsoft.com/en-us/library/2008.08.utilityspotlight.aspx) to download and install it to remove the previous MySQL installation files.

If you want to reinstall MySQL, please remember to select the correct installation package (32-bit or 64-bit) and follow the instructions to complete the installation process.

Method Five: Manually Start the MySQL Service

If trying to repair the my.ini file, check the database file, or reinstall the MySQL service does not work, you can try to manually start the MySQL service.

1. Open command prompt (administrator privileges).
2. Enter one of the following commands:

If you are using MySQL 5.5:

cd C:Program FilesMySQLMySQL Server 5.5 in
mysqld --console

If you are using MySQL 5.6 or later:

cd C:Program FilesMySQLMySQL Server 5.6 in
mysqld --console

Note: The path may vary MySQL versions vary.

3. If the command execution is successful, you can open another command prompt and try to connect to MySQL via the following command:

cd C:Program FilesMySQLMySQL Server 5.6 in
mysql.exe -u root -p

If neither method resolves the MySQL 1067 Unable to Start error, deeper investigation and repair may be required. It is best to seek professional technical support in this situation.

Summary

MySQL 1067 cannot start error is one of the very common errors. It is caused by multiple factors, including incorrect my.ini file, port number being occupied, database file damage, etc. .

When solving the MySQL 1067 cannot start error, you can try many methods such as repairing the my.ini file, changing the MySQL default port, checking the database file, reinstalling the MySQL service, or manually starting the MySQL service. If you are unable to resolve the issue, please seek professional technical support and try to resolve the issue within a certain period of time.

The above is the detailed content of mysql 1067 cannot start. For more information, please follow other related articles on the PHP Chinese website!