Windows cannot start MySQL service and reports error 1067 solution

Suddenly when I logged into MySQL, it said that access was denied or I could not connect to the database. I went back to the service and opened wampmysqld, but found that "Windows cannot start the MySQL service error 1067". I couldn't start it no matter what. What should I do? Shrimp fry, let me share my experience with you!

Method 1:

1. Open the my.ini file, find the line default-storage-engine=InnoDB, and 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 the my.ini file:
#*** INNODB Specific options *** innodb_data_home_dir="D:/"

4. Restart MySQL Service

Method 2:

When I reinstalled MySQL, it kept prompting "Unable to start MYSQL service, error 1067 The process terminated unexpectedly. Restarting and repairing the registry did not help. I checked online and changed basedir, but it did not work. I am using MySQL 5.8. After searching for a long time, I remembered that I had installed integrated environments such as wampserver and pc_webserver before. These software will write my.ini and php.ini to the C:WINDOWS directory and set them to read-only.

Solution:

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

Method 3:

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 displays normal. When connecting through mysql -u root -p, it reports an error that the server is not started. Checking the server service, it is indeed that the mysql service is not started. Manual startup generates error 1067. I have reinstalled mysql several times, but the error still exists. Check that there are no errors in each configuration.
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 haven't tried this: In fact, you don't need to reconfigure. Just click mysql.exe in the /bin directory.
mysqld.exe
mysqld-nt.exe
winmysqladmin.exe
When the prompt box appears, just cancel it and then click winmysqladmin.exe and select start the service on the small icon in the lower right corner.

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.