MySQL installation error solution, easy to use!

The following articles mainly introduce the actual solution for MySQL installation errors, including the actual solution for MySQL database service failure to start 1067, mySQL Database Installation Problems Thesecuritysettingcouldnotbeappliedtothedatabase related solutions. MySQL installation error: 1. MySQL service failure

The following articles mainly introduce the actual solution for MySQL installation errors, including the actual solution for MySQL database service failure to start 1067, the security setting cocould not be applied to the database. MySQL installation error: 1. MySQL service failure

The following articles mainly introduce the actual solution for MySQL installation errors, including the actual solution for MySQL database service failure to start 1067, the security setting cocould not be applied to the database.

MySQL installation error:

1. MySQL service cannot start 1067 Solution

When you run MySQL administrator, you cannot log on to the MySQL server. The query is incorrect and cannot be performed. in the service of the management tool in windows, it still cannot be started, and the error 1067 is reported. the solution is as follows:

1 \ enter the command prompt and enter SC delete MySQL

If the delete service is success, it indicates that the service is successfully deleted;

2 \ Run MySQLinstanceconfig in the bin directory of MySQL and reconfigure MySQL.

So far, I still don't know why this problem occurs.

In addition, SC is an advanced command provided by winxp to view and abort services. It has a strong function and deserves attention.

2. MySQL installation problems The security setting cocould not be applied to the database solution

I believe a friend has encountered this problem, especially if it was the first time to install MySQL.

Note: I am talking about MySQL problems in Windows XP.

The Problem description is generally

 
 

  
  
“The security setting could not be applied to the database because the connection has 
  
  
failed with the following error” 
 
 

I have found a lot of methods on the Internet and tried them to make them invalid. I finally found a solution to solve this problem and shared it here.

The method on the internet is generally

1. Uninstall the original MySQL and manually clear the MySQL installation directory.

2. query MySQL in the Registry and delete the registry information.

3. allow port 3306 (MySQL port) in the firewall

If you can solve the problem in the above two steps, you can try.

However, I still solve the problem through the following methods.

Important: If your MySQL service cannot be started, change the MySQL service name during MySQL installation, for example, MySQL501.

1. if your MySQL instance Configuration Wizard fails, cancel this wizard and go to the windows System Service Interface (by entering services during running. msc, and then press enter to enter the service interface) to stop the MySQL Service

2. Run the MySQL instance wizard again (MySQL service should be started at this time)

-You can choose Start> MySQL> instance Configuration Wizard to open the instance Configuration Wizard.

3. If Step 1 fails (Apply Security Settings), cancel this wizard

4. Create a txt file (for example, C: \ MySQLpassword.txt). The file content is as follows:

 
 

  
  
UPDATE MySQL.user SET Password=PASSWORD(‘mypassword’) WHERE User=’root’; 
  
  
FLUSH PRIVILEGES; 
 
 

5. Open the command line window and execute the following command

"C: \ Program Files \ MySQL Server 5.1 \ bin \ MySQLd"-defaults-file = "C: \ Program Files \ MySQL Server 5.1 \ my. ini "-init-file = C: \ MySQLpassword.txt-standalone-console

After execution, keep the window closed

6. Open another command line window and execute the following command

"C: \ Program Files \ MySQL Server 5.1 \ bin \ MySQLadmin"-u root-p shutdown

(Enter the password specified in MySQLpassword.txt)

7. Run the MySQL instance Configuration Wizard again. Apply Security Settings should be successful.

The above content is an introduction to MySQL installation errors. I hope you will find some gains.