Shulou(Shulou.com)05/31 Report--

This article mainly explains "what to do with could not start the service mysql error:0 when installing Mysql". The content in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "what to do when you install could not start the service mysql error:0 when Mysql is installed".

Could not start the service mysql error:0 processing occurs in MYSQL installation

When you have a could not start the service mysqlerror:0 error during installation or reinstallation, you can try the following two methods.

1. Mode 1

The could not start the service mysql error:0 prompt error occurred in MySQL installation. The solution is:

First, stop the MySQL service in the administrative tool-> service, then open cmd to enter your MySQL bin directory, such as C:\ Program Files\ MySQL\ MySQL Server 5.0\ bin, then use the following command mysqld-nt-remove and it will display .success! All right, let's go to the add and remove program, find MySQL and choose uninstall. Remember to choose remove. Finally, delete the MySQL directory, as well as the directory of the data library.

1. Mode 2

Check to see if there is any mysql in the service, and if so, stop the service

When installing mysql 5.1.33, there was an error in the third Start Service entry in the Execute configurattion step when running ServerInstance Configuration wizard, and the error message was Could not start the service MySQL (this is usually due to the fact that mysql is installed and uninstalled is not clean. Uninstall and reboot and then reinstall. Note that if you fail to uninstall the service, you can uninstall it with mysqld-nt-remove.

Run add and remove programs in the control panel to uninstall mysql

After uninstalling, open the registry and view the key values under HKEY_LOCAL_MACHINE\ SYSTEM\ CurrentControlSet\ Services. If there are relevant mysql key values (mysql, mysqladmin), delete them.

Restart and delete the remaining installation directory of mysql (view the service, there is no mysql in the service)

Reinstall mysql. Do not run ServerInstance Configuration wizard after installation, restart and run the wizard in the start menu.

Windowsxp system mysql-5.0.81

Tip: 1045 access denied for user 'root'@'localhost'using password yes

Collection of solutions for reporting apply security setting errors during MySQL 5.1installation

Apply security settings solution to Mysql installation error

The securitysettings could 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 fromyour 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 report apply security setting error during MySQL 5.1installation

1, uninstall MySQL

2. Delete the directory C:\ Documents and Settings\ All Users\ ApplicationData\ MySQL

3. Reinstall MySQL and OK

-

[MySQL] Could notstart the service MySQL solution

When mysql 5.1.33 is installed, there is an error in the third Start Service entry in the Execute configurattion step when running ServerInstance Configuration wizard, and the error message is Could not start the service MySQL (this is usually due to the fact that mysql has been installed and uninstalled is not clean. Uninstall and reboot and then reinstall. Note that if you fail to uninstall the service, you can uninstall it with mysqld-nt-remove.

The specific methods are as follows:

Check to see if there is any mysql in the service, and if so, stop the service

Run add and remove programs in the control panel to uninstall mysql

After uninstalling, open the registry and view the key values under HKEY_LOCAL_MACHINE\ SYSTEM\ CurrentControlSet\ Services. If there are relevant mysql key values (mysql, mysqladmin), delete them.

Restart and delete the remaining installation directory of mysql (view the service, there is no mysql in the service)

Reinstall mysql. Do not run Server InstanceConfiguration wizard after installation, restart and run the wizard in the start menu.

PS: a method worthy of reference

-

Msyql installation to the last step start service error resolution

1. Delete the mysql in the control panel first.

two。 Go to the C:\ Program Files directory and delete the mysql directory.

3. If there are settings on other disks, delete them as well. The empty directory should also be deleted.

4. Go to regedit to put 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 there is, delete it all!

(tip: use F3 loop to find "mysql")

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

6. Turn off the firewall.

7, reinstall mysql (I didn't restart my computer here)

If necessary to reinstall, restart the computer, deactivate IIS, and delete temporary files in temp.

If it really doesn't work, when configuring mysql, change the mysql service name to another service name.

*

-

Error deleting item.

-

Unable to delete LEGACY_MYSQL51: error deleting item.

-

Confirm

-

Solution: right-click in the registry entry to add all administrators permissions

Cannot createwindows service for mysql.error:0 errors may occur when installing mysql, most of which are caused by reinstalling mysql or upgrading mydql and using MySQLConfiguration Wizard.

Solution: go to regedit to put the registry, use F3 loop to find "mysql", delete all, reinstall mysql, you can.

Thank you for reading, the above is the "Mysql installation of could not start the service mysql error:0 how to do" the content, after the study of this article, I believe you have a deeper understanding of how to install Mysql could not start the service mysql error:0 how to do this problem, the specific use of the situation also needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.