Solution for unsuccessful installation of MySQL Apply Security Settings

MySQLDatabase InstallationMySQL Apply Security SettingsFailure is a headache for us. If you think about it, it is actually not as difficult as you think. The reason for the failure is that you have some permission problems or some services that are not enabled, it is much easier to solve the problem. This article introduces this solution. Next, let's take a look at this solution process.

The solution is as follows:

Open the command prompt administrator permission: Start-Program-attachment-command prompt-right-click-run as administrator ).

Run net stop mysql. If MySQL has been started, close it and switch to the bin directory of MySQL.

Run SC delete mysql to delete existing services, run mysqld -- install to manually install the services, and then run net start mysql to start the MySQL service.

If the service starts successfully, execute mysql-u root-p and you will be prompted to enter the password, enter your password, and then connect to the database.

Execute UPDATE mysql. user SET password = PASSWORD 'new password') WHERE user = 'root'; flush privileges; modify the root password.

OK. Everything is done.

At this point, MySQL Apply Security Settings can be successfully installed. This article will introduce it here, hoping to bring you some benefits!