Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: YES)

[Adam M]

I had this same problem, annoyed me for hours...

What I have realised is that the "MySQL Server Instance Config Wizard" does NOT set your password!

This is what I did....

I clicked Skip on the dialog that states the Error 1045...
Then cancelled the "MySQL Server Instance Config Wizard"

Now...

Open a command prompt type "mysql -u root -p" then hit enter again when it requests a password.

You should now have access to the mysql monitor...

type the following at the prompts...

mysql>use mysql
mysql>select user, host, password from user;
# Now you should see that u have 3 entries
+-----------------------------+
| user | host | password |
+-----------------------------+
| root | localhost | |
| root | 127.0.0.1 | |
| | localhost | |
+-----------------------------+

mysql> delete from user where host="localhost" and user="";
mysql> update user set password=password("xxxx") where user="root";
mysql> flush tables;
mysql> flush privileges;
mysql> quit

Now the mysql table should be updated and everything fixed.

Try it out...

At the command prompt type "mysql -u root -p" then hit enter your new password when it requests.

As long as you have allowed an exception for MySQL on port 3306 in either windows firewall or any other firewall software you're using, things should work fine...