Solve the problem that MySQL cannot be fully detached when the mysql service cannot be started in windows. MySQL Solution

Source: Internet
Author: User

Solve the problem that MySQL cannot be fully detached when the mysql service cannot be started in windows. MySQL Solution

The following articles mainly describe the actual solution that cannot be fully detached when the MySQL service cannot be started, the following is a description of the specific solution when the MySQL service cannot be started. I hope it will be helpful for you in your future studies.

Solution to apply security setting error during MySQL 5.1 Installation

1. uninstall MySQL

2. Delete the directory C: \ Documents ents and Settings \ All Users \ Application Data \ MySQL.

3. reinstall MySQL.

[MySQL] cocould not start the service MySQL Solution

Install MySQL 5.1.33. An error occurs in the third Start Service in the Execute strongattion step when the Server Instance Configuration wizard is running, the error message "cocould not start the service MySQL" is displayed. (This is generally because MySQL is installed and cannot be uninstalled. Uninstall and restart before reinstalling. Note that you can use MySQLd-nt-remove to uninstall the MySQL service ).

The specific method is as follows:

Check whether MySQL is in the service. If yes, stop the MySQL service;

Run the Add/delete program on the Control Panel to uninstall MySQL;

Open the registry after uninstalling and view the key values under HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services. If there is a MySQL key value (MySQL, MySQLadmin), delete it;

Restart and delete the residual directory of MySQL installation (view the service, MySQL Service does not have MySQL );

Reinstall MySQL. After installation, do not run Server Instance Configuration wizard. After restart, run the wizard in the Start Menu.

PS: A Reference Method

Msyql installation to the last step start service error Solution

1. In the control panel, delete MySQL first.

2. Delete the MySQL directory under drive C: \ Program Files.

3. If you still have a directory set on another disk, you must also delete the. Empty directory.

4. Go to regedit to set the Registry

HKEY_LOCAL_MACHINE/SYSTEM/ControlSet001/Services/Eventlog/Applications/MySQL HKEY_LOCAL_MACHINE/SYSTEM/ControlSet002/Services/Eventlog/Applications/MySQL HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Eventlog/Applications/MySQL then, delete all!

(Tip: Use F3 to search for "MySQL" cyclically ")

5. If MySQL content in the task manager is also deleted

6. Shut down the firewall.

7. reinstall MySQL (I have not restarted the computer here)

Restart the computer, disable IIS, and delete temporary files in temp if necessary.

If this is not the case, change the MySQL service name When configuring MySQL.

An error occurred while deleting the item.

Unable to delete LEGACY_MySQL51: An error occurred while deleting the item.

OK

Solution: Right-click the registry key to add all the permissions for administrators.


I used to have no problem with mysql. After I uninstalled and reinstalled it, I couldn't start it any more. I was prompted that the MySQL service could not be started (1067). How can I solve this problem?

This is a syntax error.

MYSQL service cannot start 1067 Solution

I entered net strat mysql in the CMD window to start the service and then MYSQL-h localhost-u root-P. I don't know if it is helpful to you.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.