System Error 1067 Occurs

Question

Some problems with XAMPP occurred after MySQL did not start. So, I typed in the command line: "net start MySQL", and he gave me this error message indicated on the subject line.

Does anyone know how to mitigate this? Thank you for your help!

Answer 1

This did the trick for me:

https://serverfault.com/questions/214435/error-1067-the-process-terminated-unexpectedly-when-trying-to-install-mysql-on/214846#214846

Of course, in this case you should completely clear the xampp folder , which does not always happen. I assume that I first backed up the necessary files (the data folder from the mysql folder and the htdocs folder). Remove XAMPP. Check the xampp folder for any remaining content and delete everything. Just in case, you can reboot. Then reinstall XAMPP. Copy the backup folders back to the appropriate places and hopefully mySql will work again in XAMPP.

Answer 2

In my case, this was enough to give the full (absolute) path to the xampp/mysql/bin/my.ini file. For example, I changed basedir from "/xampp/mysql/" to: "E:/xampp/mysql/" , etc.

Answer 3

This or this can help you if you're on windows.

According to reports, uninstalling and then reinstalling with the -defaults-file option will fix the problem. Make sure the service manager window is closed, as this may cause strange errors when trying to fix the problem.

Answer 4

You can re-register your mysqld as a service and point to the my.cnf file for the appropriate set of data directories: See http://www.jerrytravis.com/?p=533 for instructions on how to do this. The article in the link refers to doing this when you move the Zend Server folder, however the procedure will work for any msyql installation. Just cd to the appropriate directories.

Answer 5

I ran into the same problem. Here is a solution that works for my situation. In my case, I already installed xamp with mysql listening on port 3306, also I have mysql 5.0 listening on port 3307. Then I try to install 64-bit mysql version 5.6 while listening on port 3308, I already define it in my.ini, and then run cmd (should be open by running it as an administrator). My installation was "d: \ mysql64", then go to this folder in the cmd dialog, then type "bin \ mysqld --install mysql64 --default-file = d: \ mysql64 \ my.ini". It was said that the service was installed successfully, but when I try to start it using "net start mysql64", it gives this error 1067. I also already try to install and reinstall several times by changing my.ini, but the problem persists.

The solution is =

• remove the service using "bin \ mysqld --remove mysql64"

• reinstall the service using "bin \ mysqld --install mysql64 --port = 3308" ----> this solution

• try starting mysql64 through windows services or through "net start mysql64"

It will start successfully.

So, in this case, it seems that the -default-file argument was ignored by the window manager, because I already define the port in my.ini, but the service cannot start and give error 1067

Answer 6

I had the same problem, but on the windows. I found that the service was created under a privileged account (in my case nt_authority). When I changed this to a "system" account, everything worked.

Answer 7

I think that at least a warning should be added to the product when the user tries to install MySQL along a path containing spaces. This caused the "System Error 1067 Error" error, which disappeared after reinstalling MySQL under empty without spaces (C: \ Programs is used instead of C: \ Program Files, which, unfortunately, appears in German Windows 10 as C: \ Program, t .e. Without any spaces!).