mysql service 1067 error and solution

This article mainly introduces the solution to the Mysql service 1067 error: modify the relevant information of the mysql executable file path. Friends in need can refer to it

Encountered the mysql service today 1067 error problem. Mysql cannot be started using the system account. After checking the system configuration information after authentication, I found that the startup file is mysqlinstallation. The path is the same as before (it also means that mysql was installed before and was not uninstalled. Installing the new one directly will cause an error), so I plan to modify the mysql executable file path and replace it with the current one.

But various Baidu explanations were not clear. Later I planned to give up and simply reinstalled the system, only to find that this could be solved.

Step 1: Stop the service MySQL

Step 2: (Console: Run->regedit), according to the path HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\, find the path you want to change Services, you can also use the search function that comes with the registry to find the path you want to modify

Run->regedit

Go here 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

[Related recommendations]

1. Free mysql online video tutorial

2. MySQL latest manual tutorial

3. Those things about database design

The above is the detailed content of mysql service 1067 error and solution. For more information, please follow other related articles on the PHP Chinese website!