MySQL database installation MySQL Apply Security settings unsuccessful

mysql database installation mysql Apply Security Settings is not a success, it is a headache for us. Think about it, in fact, it is not so difficult to imagine, the cause of the failure is just some of the permissions or some of the services are not open, know that, we can solve it is much easier. This article introduces this solution, so let's take a look at the solution.

The solution is as follows:

Open a command prompt (Administrator rights: Start-Programs-Attachments-command prompt-right-run as administrator).

Execute net stop MySQL if you have started MySQL, turn it off, and then switch to the MySQL bin directory.

Execute the SC delete MySQL to delete the existing service, perform the Mysqld--install manual installation service, and then execute the net start MySQL service.

If the service starts successfully, executing mysql-u root-p prompts you to enter your password, enter your password, and then connect to the database.

Execute update mysql.user SET password=password (' New password ') WHERE user= ' root '; FLUSH privileges; change root password.

OK, everything is done.

To this, has been able to successfully install MySQL Apply Security settings, this article introduced here, hope to bring you some harvest!

MySQL database installation MySQL Apply Security settings unsuccessful