MySQL 5.6 decompressed version service cannot be started due to system error 1067

Record the BUG that got me stuck all afternoon today

Let's start from half a month ago.

then.....................................................................................................................

...........................................................................................................................................

Then uninstall the Mysql5.5 installed on the local computer

Go to the official website and download the unzipped version of 5.6

Then unzip

Configure the environment variables and add D:\software\mysql5.6\mysql5.6.45\bin to the path.

This is my own

Then modify the configuration file, the default .ini file

Don't save a my.ini file as someone on the Internet (this is the culprit that caused you to be trapped for an entire afternoon), just change it directly in the configuration file ----- yellow eye-catching

I only changed these three, please change them according to your own situation.

And then what did you do? . . . .

By the way, run cmd as an administrator and enter the bin directory

mysqld -install prompts success

net start mysql service started successfully

If these two steps are successful, then there is nothing wrong with the installation and configuration. The next step is to set the initial password. I also looked it up online because no password is required by default.

mysqladmin -u root -p password , press Enter, then Enter again, enter both passwords and you're done.

I spent the whole afternoon on this. People on the Internet said that I should save a separate my.ini file. But it is not necessary at all. I can just modify it on the previous one. Fortunately, I am smart. I really want to give a thumbs up for my smartness.

Summarize

The above is the system error 1067 problem that the MySQL5.6 decompressed version service cannot be started. I hope it will be helpful to everyone. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!
If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!