Solutions to Common Errors During MySQL Database Installation

MySQL databaseSome errors often occur during installation or uninstallation. This is a headache for us. This article describes solutions to several common errors during MySQL database installation.

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 service if it fails to be uninstalled ).

The specific method is as follows:

Check whether mysql is in the service. If yes, stop the 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 (check that mysql is no longer available in the service ).

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

Msyql installation to the last step start service error Solution

1. Delete mysql in the control panel.

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

3. If you still have a directory set on another disk, 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 
 
 

If yes, delete all! Tip: search for "mysql" cyclically with F3 ")

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

6. Shut down the firewall.

7. I have not restarted the computer here to reinstall mysql ).

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.

I will introduce the troubleshooting of MySQL database errors during the installation process. I hope you will get some benefits!