Home  >  Article  >  Database  >  How to solve the problem of mysql unable to start 1067 error

How to solve the problem of mysql unable to start 1067 error

藏色散人
藏色散人Original
2021-12-06 15:06:329273browse

Mysql cannot start 1067 error solution: 1. Open the my.ini file and modify "default-storage-engine=MyISAM"; 2. Delete ib_logfile0 and ib_logfile1; 3. Restart the MySQL Service.

How to solve the problem of mysql unable to start 1067 error

The operating environment of this article: Windows7 system, mysql5.8, DELL G3 computer

How to solve the problem that mysql cannot start 1067 Wrong question?

Windows cannot start MySQL service error 1067 solution

When suddenly logging into MySQL, access is prohibited or unable to connect to the database, return to the service, go Open wampmysqld and find "Windows cannot start MySQL service error 1067". It cannot be started. What should I do? Let me share my experience with shrimp fry!

Method 1:

1. Open the my.ini file, find the line default-storage-engine=InnoDB, and change Change it to default-storage-engine=MyISAM.
2. Delete ib_logfile0 and ib_logfile1 in the Data directory under the MySQL installation directory
3. Find the InfoDB directory specified when configuring the MySQL server and delete ibdata1

According to my.ini In the file:
#*** INNODB Specific options *** innodb_data_home_dir="D:/"

4. Restart MySQL Service

Method 2:

When reinstalling mysql, it keeps prompting "Unable to start the MYSQL service, error 1067. The process terminated unexpectedly. Restarting and repairing the registry are of no use. I checked online and changed the basedir, but nothing happened. I am using mysql5.8. After searching around, I remembered that I had installed integrated environments such as wampserver and pc_webserver before. These softwares would write my.ini and php.ini into the C:WINDOWS directory and set them as read-only. .

Solution:

Delete the my.ini file in the windows directory,
Reinstall mysql, the service starts successfully

Method three:

1. Execute winmysqladmin to generate the my.ini file

2. Mysqld -install starts the mysql service

3. Net start mysql starts the mysql service and the display is normal. When connecting through mysql -u root -p, an error that the server is not started is reported. Check the server service. It is true that the mysql service is not started. Manual startup generates a 1067 error. I have reinstalled mysql several times. The error remains. Check all configurations and there are no errors.
My system environment is win2003 mysql version 4.0.12. The solution is to copy the my.ini generated by winmysqladmin to c:windows and then start mysql and everything will be OK. I have not tried this. Note: In fact, there is no need to reconfigure. You just need to click mysql.exe
mysqld.exe
mysqld-nt.exe
winmysqladmin.exe
cancle directly after the prompt box appears
Then click winmysqladmin.exe and select Start the service on the small icon in the lower right foot.

Recommended learning: "mysql video tutorial"

The above is the detailed content of How to solve the problem of mysql unable to start 1067 error. 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