Solution to MySQL service 1067 error: modify the mysql executable file path

Today I encountered the MySQL service 1067 error problem. I couldn't start MySQL even after setting it to use the system account. After authenticating and looking at the system configuration information, I found that the startup file, that is, the MySQL installation path, was the previous one (which also means that if I installed MySQL before and installed a new one without uninstalling it, an error would occur). So I plan to modify the MySQL executable file path and change it to the current one.

However, all the answers on Baidu were vague, so I decided to give up and reinstall the system, only to find that this problem could be solved.

Step 1: Stop MySQL service

Step 2: (Console: Run->regedit), find the service you want to change the path of according to the path HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\, or use the search function of the registry to find the path you want to modify

Run->regedit

Here you can see the mysql executable file path"

We can write the new path in, mine is "D:\SOFT_PHP_PACKAGE\mysql\bin\mysqld" –defaults-file="D:\SOFT_PHP_PACKAGE\mysql\my.ini" MySQL

The above is the solution to the Mysql service 1067 error introduced by the editor: modify the mysql executable file path. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!