MySql security settings could not be applied to the database

Asked By Richard M Dingman 0 points N/A Posted on - 04/03/2014

Hi there,

Yesterday I got this error message during the last step of the MySQL Windows installer and at this moment I don’t have a solution to solve it. I had to reinstall MySQL because of my Windows XP and I never had this error before. Can anyone help me to fix this ? Is there a problem with my new Windows XP ?

Thanks !

Connection Error

The security settings could not be applied to the database because the connection has failed with the following error.

• Status: Open
• Question Views: 1117
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Alan Keyes 0 points N/A #173719

MySql security settings could not be applied to the database

Hello There,

 

You may try these steps :-

 

Cancel wizard and STOP MySQL service.

Create text file using below statements – reset root password.

 

UPDATE mysql.user SET Password=PASSWORD('admin') WHERE User='root';   Now fire – FLUSH PRIVILEGES;

 

Then, launch mySQL using the following command line:

 

mysqld –defaults-file="C:Program FilesMySQLMySQL Server 5.5my.ini" –init-file="C:mysql-init.txt" –console

 

Once this is done, open command prompt and execute

 

1	mysqladmin -u root -p shutdown

 

Now you are free to restart mySQL installer and choose “Repair”

 

About Alan Keyes

Questions
0

Answers
100

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 05/10/2014
• Question Category: MySQL Server