Method: 1. In the "my.ini" file, change the content of "default-storage-engine" to MYISAM; 2. Delete "ib_logfile0" and "ib_logfile1" in the data in the MySQL directory and ibdata1 and then restart the database.
The operating environment of this tutorial: windows10 system, mysql8.0.22 version, Dell G3 computer.
The local computer cannot start the MYSQL service error 1067. The process terminated unexpectedly. This situation is usually caused by an error in the my.ini file configuration
First find this file: Default installation path
C:/Program Files/MySQL/MySQL Server/my.ini
1. Open this file and find: default-storage-engine=INNODB About line 84.
Change the value of default-storage-engine to: MYISAM. At this time, the MYSQL service can be started.
#2. Find the data file
But there is still a problem: because the databases you created before still exist (if not Delete),
Default path:
C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server/data
This problem may occur at this time:
The default-storage-engine set for the first time and the one set for the second time Different values may lead to
1: It is found that it is impossible to choose to add transaction support data engine InnoDB
2: It may be said that InnoDB is not supported, etc.
Solution:
Delete:
ib_logfile0 ib_logfile1 ibdata1
Restart the service and generate again and it will be OK
Recommended learning:mysql video tutorial
The above is the detailed content of What should I do if error 1067 is reported when mysql starts?. For more information, please follow other related articles on the PHP Chinese website!