N/APosted on - 04/03/2014
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 ?
The security settings could not be applied to the database because the connection has failed with the following error.
MySql security settings could not be applied to the database
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 –
Then, launch mySQL using the following command line:
FilesMySQLMySQL Server 5.5my.ini" –init-file="C:mysql-init.txt" –console
Once this is done, open command prompt and execute
mysqladmin -u root -p shutdown
Now you are free to restart mySQL installer and choose “Repair”