Shulou(Shulou.com)05/31 Report--

This article will explain in detail what to do when there is a service 1067 error in mysql. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

Solution to mysql service 1067 error: 1. Find default-storage-engine=INNODB, change INNODB to MYISAM;2, and add "basedir=C:\ Program Files\ MySQL..." to my.ini. That's it.

This article operating environment: Windows7 system, mysql5.5 version, Dell G3 computer.

MySQL service startup error: 1067

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

The problem begins.

The first thing to do after turning on the computer is to start the MySQL service, but here comes the problem. Error 1067

Solution / step 1

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

Rush to start the MySQL service in high spirits, but still no service starts, so abandon this method and use method 2

Method / step 2

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

Next, open the new my.ini and add after the last line

"[mysqld] # set the installation path where basedir points to mysql basedir=C:\ Program Files\ MySQL\ MySQL Server 5.5datadir=C:\ Program Files\ MySQL\ MySQL Server 5.5\ data"

Just save it.

Note: you should write your own installation path, don't just copy it without modifying it.

Finally, start our MySQL service and start it normally.

This is the end of the article on "what to do if there is a service 1067 error in mysql". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.