Win7 Ultimate computer can not start MySQL service, prompt error 1067 how to do

  

What is MySQL? Probably for most users, this MySQL is not very well understood, in fact, MySQL is a relational database management system, if If you are a friend of the website, you should be very familiar with it, because the development of small and medium-sized websites generally chooses MySQL as the website database. However, recently users who use the w764 flagship computer found the problem, saying that their win7 Ultimate computer can not log in to the mysql service, saying that there will always be 1067 error prompts, then how to solve this problem? ?

1. First, we need to find and open the my.ini file in our win7 Ultimate computer. After that, we can find the default-storage-engine=InnoDB option and change it to Default-storage-engine=MyISAM.

2. In the second step, we need to find the Data directory in the MySQL installation directory. After that, we can find two options ib_logfile0 and ib_logfile1 in this Data directory.

3. In the third step, we need to find the InfoDB directory specified when configuring the MySQL server. After we find it, we can find ibdata1 in this directory and delete it.

After completing the above settings, we need to restart our win7 Ultimate computer. After the restart, the settings made in the win7 Ultimate computer can take effect.

If you think that the above operation is more troublesome, you can try to fix the win7 Ultimate computer. After the repair, the fault can be solved, but before that, we need to back up the articles in the computer.

Note: For more exciting tutorials, please pay attention to the computer tutorial section, computer office group: 189034526 welcomes you to join

Copyright © Windows knowledge All Rights Reserved