MySQL installation error apply security settings, connection error error1045

MySQL installation error apply security settings, connection error error1045,

The error types include:

The Security Settings cocould not be applied to the database because the connection has failed with the following error.

Error Nr. 2003

Can't connect to MySQL server on 'localhost' (10061)

If a personal firewall is running on your machine, please make sure you have opened the TCP port 3306 for connections. otherwise no client application can connect to the server. after you have opened the port please press [retry] To apply the security settings.

If you are re-installing after you just uninstalled the MySQL server please note that the data directory was not removed automatically. therefore the old password from your last installation is still needed to connect to the server. in this case please select
Skip now and re-run the Configuration Wizard from the Start Menu.

**************************************** **************************************** *********

The Security Settings cocould not be applied to the database because the connection has failed with the following error.

Error Nr. 1045

Access denied for user 'root' @ 'localhost' (using password: Yes)

If a personal firewall is running on your machine, please make sure you have opened the TCP port 3306 for connections. otherwise no client application can connect to the server. after you have opened the port please press [retry] To apply the security settings.

If you are re-installing after you just uninstalled the MySQL server please note that the data directory was not removed automatically. therefore the old password from your last installation is still needed to connect to the server. in this case please 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 \ 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 not available in the Service );

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

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 create Windows Service for MySQL. Error: 0 error may occur during MySQL installation. Most of the causes of the error are caused by re-installing MySQL or upgrading mydql using MySQL Configuration Wizard.

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