Sometimes you will encounter Error 1067: The process terminated unexpectedly because the service you are trying to start is corrupted or corrupted. Thus, you can try uninstalling and installing the service to fix the problems.
I encountered the same errors. Something like this for me. As far as I know, something strange is happening with the reference to the
data directory in the
my.ini file. Even though I edited it by hand, I couldn’t affect it until I blew EVERYTHING. Wish I had better news … back up the database first.
For me the key to this job was:
1) Remove the previous installation of
Settings-> Control Panel . Reboot your computer.
2) Remove the previous installation directory after restarting your computer. [mine is
C: apps MySQL MySQLServer-5.5 because I refuse to use
c: program files .. ]
3) Force delete the previous data directory [mine was
c: data mysql ].
4) Delete the previous standard data directory [
C: Documents and
Settings All users Application data MySQL ].
5) Run the installation again and select the same installation directory. Ignore the
Configurator / Assistant instance at the end of the installation.
6) Make sure the
../bin directory is added to the path. Check this.
7) Manually run configscurator / wizard for creating instances of
Set the root password for port [
3306 ]. He will try to run it. Again mine could not start [moron! nothing new !!!]
8) Now manually edit the
my.ini file in the installation directory and change the
datadir parameter to [
datadir = "C: / Data / MySQL /" < / code>] MAIN ENTRY !!!!
9) Check with the command line [
sc qc mysql ] that the service is configured correctly.
It should look like this:
C: dev cmdz> sc qc mysql[SC] GetServiceConfig SUCCESSSERVICE_NAME: MySQL TYPE: 10 WIN32_OWN_PROCESS START_TYPE: 2 AUTO_START ERROR_CONTROL: 1 NORMAL BINARY_PATH_NAME: "C: apps MySQL MySQLServer-5.5 bin mysqld" --defaults-file = "C: apps MySQL MySQLServer-5.5 my.ini" MySQL LOAD_ORDER_GROUP: DAY: 0 DISPLAY_NAME: MySQL DEPENDENCES: SERVICE_START_NAME: LocalSystem
10) Copy the contents of the standard data directory that was created in
C: Documents and Settings All Users Application Data MySQL [basically everything in this directory so that the desired data directory is
c: data mysql ]. Make sure you have
C: Documents and Settings All Users Application Data MySQL mysql directory. It contains the file
host.frm and others.
Now you have dThere should be a directory with
c: data MySQL mysql ...
11) Rename the default directory
C: Documents and Settings All Users Application Data MySQL IN
C: Documents and Settings All Users Application Data MySQLxxx So he can't find it ...
12) Say a short prayer ...
13) Start with [
net start mysql ]
from the command line
It worked for me ...
The file system is damaged.
Solution 1: Take Control Of The Service
This issue is usually associated with different permissions and can be resolved by giving your personal user profile access to service commands. This method should be your number one priority for several reasons.
Firstly, it is versatile and can be applied no matter which service displays the 1067 error message. Secondly, it is easy to do, and changes can be reverted in no time.
- Open the Run utility with the Windows key R key combination on your keyboard (press these keys at the same time. Enter "Services.msc" in the newly opened box without quotes and presse "OK". to open the service tool.
- Another option is to open the Control Panel by finding it in the Start Menu. You can also find it using the search button on the start menu.
- With the Control Panel window open, change the View By option in the upper right corner of the window to Large Icons and scroll down until you find Administrative Tools. Click on it and find the "Services" link below. Click on it to open it as well.
- Find the service that is causing the error in the list of services, right-click it and select Properties from the context that appears There is a different menu.
- If the service is starting (you can check this right next to the service status message), you need to stop it now by clicking the Stop button in the center of the window. If it is stopped, leave it until we continue. Go to the "Connection" tab and click the "Browse" button ...
- Enter your account name in the Enter the object name to select entry field, click Check Names and wait for the name to become available.
- When finished, click OK, and then enter your password in the Password field when prompted if you have set a password. Everything should start now without any problems!
Solution 2: Reinstall The Problematic Service
This method can also be used to fix error 1067 on any problematic service, as long as it can be removed using Registry Editor. This is an advanced restart method A damaged service that cannot be fixed by simply restoring the services.
- Since you want to delete a registry key, we recommend that you read this article that we have posted so that you can safely back up the registry and avoid further problems. However, if you follow the instructions carefully and correctly, you can't go wrong.
- Open the Registry Editor window by typing "regedit" in the search bar or in the Run dialog, which can be opened with the Windows key R key combination. Go to the next section in your register by going to the left pane:
HKEY_LOCAL_MACHINE SYSTEM CurrentControlSet Services
- In the public service key, locate the problematic service key, right-click it and select the Delete option. Confirm all unfinished dialogs, then reload compewter.
Note. If you are unable to remove this key, you may need to add Advanced Access to your account. This can always be done in the registry editor.
- In the left navigation bar, right-click the problematic service button and select Permissions from the context menu.
- In the Group or Usernames section, try to find your computer's username in the list. If you can't find it, click Add >> More >> Find Now. You should see your account in the search results. Select it and click OK twice until you return to the Permissions folder.
- Select y