Today, I get error like this when installing mysql on my computer :
The security settings could not be applied to the database because the connection has failed with the following error.
Error Nr. 1045
Access denied for user ‘root’@’localhost’ (using password: NO)
So, what caused it?
The error caused by : my
new root password ‘not match’ with my
old root password.
For you know, previously i have been installed mysql and set the root password. When i upgrade mysql, i install mysql again and set different root password. That is the problem. The password is
So, how to fix it?, Follow the following step :
1) Uninstall mysql.
First, uninstall mysql through control panel or by mysql installer.
2) Remove mysql data
Next, remove mysql data to remove mysql user (like root user, etc).
If you can’t see
ProgramData folder, maybe the folder is hidden.
hope is useful!