Summary of mysql Installation Problems and mysql Installation Problems

Summary of mysql Installation Problems and mysql Installation Problems
When MYSQL is installed, cocould not start the service mysql error: 0 is processed.


When you encounter the cocould not start the service mysqlerror: 0 error during installation and reinstallation, you can try the following two methods.


I. method 1
When installing MySQL, the error "cocould not start the service mysql error: 0" is displayed. solution:
First, stop MySQL services in the management tools> services, and then open cmd to enter your MySQL bin directory, such as C: \ Program Files \ MySQL Server 5.0 \ bin and then use the following command mysqld-nt-remove to display ...... success! Now go to add and delete programs, find MySQL and select Uninstall. Remember to select remove. Finally, delete the MySQL directory and the database directory.


I. method 2
Check whether mysql is in the service. If yes, stop the service;
Install mysql 5.1.33. An error occurs in the third Start Service in the Execute strongattion step when running the ServerInstance Configuration wizard, 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 ).


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 the service has no mysql

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


Windows XP mysql-5.0.81
Tip: 1045 access denied for user 'root' @ 'localhost' using password yes


Solution to apply security setting error during MySQL 5.1 Installation
Mysql installation error apply security settings Solution


The securitysettings cocould not be applied to the database because the connection has failedwith the following error.


Error Nr. 1045


Access denied foruser 'root' @ 'localhost' (using password: YES)


If a personalfirewall is running on your machine, please make sure you have opened the TCPport 3306 for connections. otherwise no client application can connect to theserver. after you have opened the port please press [Retry] to apply thesecurity settings.


If you arere-installing after you just uninstalled the MySQL server please note that thedata directory was not removed automatically. therefore the old password fromyur last installation is still needed to connect to the server. in this caseplease select skip now and re-run the Configuration Wizard from the start menu.


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 \ ApplicationData \ MySQL.


3. reinstall MySQL.


------------------------------------------


[MySQL] cocould notstart the service MySQL Solution

Install mysql 5.1.33. An error occurs in the third Start Service in the Execute strongattion step when running the ServerInstance Configuration wizard, 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 not available in the Service );


Reinstall mysql. After installation, do not run Server InstanceConfiguration 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

If yes, 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.


The cannot createwindows service for mysql. error: 0 error may occur during mysql installation. Most of the causes of the error are due to the re-installation of mysql or the mydql upgrade using MySQLConfiguration Wizard.


Solution: Go to regedit and run F3 to search for "mysql". Delete All and reinstall mysql.

An error occurred while installing Mysql.

1. You need to configure my. ini (windows) or my. cnf (linux)
2. Install Windows 7/win8 as an administrator to install the mysql service.

An error occurred while installing mysql.

The update is in progress. You can directly download the latest package for installation. It will take some time for the update.

Feature selection is a personalized choice. We recommend that you select all of them. You do not need to reinstall or update them later.