How to solve the MySQL reinstallation problem _ MySQL

Source: Internet
Author: User
How to solve the problem of MySQL reinstallation: bitsCN.com

I recently encountered a problem of MySQL reinstallation at work. today I will record my solution process.

First of all, for some reason, I have to uninstall mysql and then reinstall mysql. no matter how I use the control panel to uninstall and delete programs or the security guard, I will encounter a problem, it is installed to a location like this. When server start is started, the program will not respond, and it will always die there:

As a result, I tried to find a solution everywhere on the internet. according to most people's statements, I tried not to do it. I died:

The installation of MySQL shows no response. generally, it shows that the 2 or 3 items in the last step of installing the MySQL program will not change.

This is generally because the MySQL database service item you have installed is occupied.

Solution:

One way: when you can install MySQL, the default service name is "MySQL" in this step. you only need to change this name.

Two methods:
1. uninstall MySQL
2. delete the installation directory and data storage directory
3. query mysql in the registry (regedit) and delete all
4. query MySQL on drive C and delete all
5. just reinstall it.

Note that the registry cmd-> regedit
1. HKEY_LOCAL_MACHINE/SYSTEM/ControlSet001/Services/Eventlog/Application/MySQL Directory
2. HKEY_LOCAL_MACHINE/SYSTEM/ControlSet002/Services/Eventlog/Application/MySQL Directory
3. HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Eventlog/Application/MySQL Directory
4. HKEY_LOCAL_MACHINE/SYSTEM/CurrentControl001t/Services/MYSQL Directory
5. HKEY_LOCAL_MACHINE/SYSTEM/CurrentControl002/Services/MYSQL Directory
6. HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/MYSQL Directory
7. delete the C:/Documents and Settings/All Users/Application Data/MySQL Directory
You can choose either of the above two methods. it is OK to reinstall the new MYSQL version.

Note: After the deletion is complete, you must restart the computer before installing it.

I installed it for one afternoon using the above method, but it still won't work.

Finally, because my Server is Windows Server 2008 RC

So I want to see if it is a compatibility issue. here is the latest mysql5.5.28.

So in this step, I removed the check:

Find the program named mysqlinstanceconfig.exe under the binfile folder in the mysqlinstallation directory, and right-click the property, as shown in settings:

Double-click mysqlinstanceconfig.exe.

BitsCN.com

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.