What should I do if error 1067 is reported when mysql starts?

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.

What to do if mysql starts with error 1067

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!