How to solve mysql service 1067 error problem

Mysql service 1067 error solution: 1. Find default-storage-engine=INNODB and change INNODB to MYISAM; 2. Add "basedir=C:\Program Files\MySQL." to my.ini. ..” That’s it.

The operating environment of this article: Windows 7 system, mysql5.5 version, Dell G3 computer.

How to solve the mysql service 1067 error problem?

MySQL service startup error: 1067

The MySQL service may fail to start (error: 1067) for some reasons. Here we describe the author's Solution

The problem started

The first thing I did after turning on the computer was to start the MySQL service, but the problem came and error 1067

Solution/Step 1

Go to the MySQL installation directory and find my.ini, open it with an editor, find default-storage-engine=INNODB, and change INNODB is modified to MYISAM

I rush to start the MySQL service, but there is still no service started, then give up this method and use method 2

Method/Step 2

First go to the MySQL installation directory and delete my.ini, then copy my-small.ini to my.ini

Next open the new my.ini, add

“
[mysqld]
#设置basedir指向mysql的安装路径
basedir=C:\Program Files\MySQL\MySQL Server 5.5
datadir=C:\Program Files\MySQL\MySQL Server 5.5\data
”

after the last line and save it

Note: You must write your own installation path, don’t just Copy without modification

#Finally, start our MySQL service and it will start normally

[Recommended Study: mysql video tutorial】

The above is the detailed content of How to solve mysql service 1067 error problem. For more information, please follow other related articles on the PHP Chinese website!