Starting MySQL encounters 1067 issues

A few problems occurred when I recently installed SQL: 1067 error when booting up

Find a lot of methods on the Internet, such as delete the MySQL installation directory date bdata1, IB_LOGFILE0,. And so on the InnoDB file,

For example, modify the contents of the My.ini file.

But the results do not seem so ideal, and finally how to solve?

Maybe you need to clean up MySQL management information just as much as I do.

Input c:\mysql\bin\mysqladmin-u root-p shutdown

So you can use net start MySQL.

The cause of this problem is probably a misconfiguration of the information in My.ini.

The following is the complete installation process.

First step: Open the MySQL unpacking package, locate My-default.ini, back it up, and then replace the name with My.ini

Step Two: Open My.ini

Enter the following information

[Client]port=5200default-character-Set=Utf8[mysqld]port=5200  character_set_server=Utf8basedir=C:\mysql    #{here for your MySQL installation path} #解压目录datadir= C:\mysql\data      #{here for your MySQL installed path under the data} #解压目录下data目录sql_mode=no_engine_substitution,strict_ Trans_tables[winmysqladmin]c:\mysql\bin\mysqld.exe  #{is also your MySQL installation path under the bin path under the Mysqld.exe}

Step three: Open the Command Control window

Go to the Bin directory in the MySQL installation directory

As follows:

Start installing MySQL

Input Mysqld--install

Fourth step, we're back to the beginning.

Input mysqladmin-u root-p shutdown

The default password here is empty

And finally the input startup service net start MySQL

Starting MySQL encounters 1067 issues