MySql security settings could not be applied to the database

Asked By 0 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 0 points N/A #173719

MySql security settings could not be applied to the database

qa-featured

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”

 

Related Questions