Thursday, September 24, 2009

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

Error Nr. 1045 Access denied for user 'root'@'localhost' (using password: YES) in MySQL installation (Windows).
Are you getting this error when you install MySQL in Windows XP box?
And the Fourth step (Security Settings) in the Execution of Config wizard gives trouble?

Don't bother to reset root password, etc, etc.. which doesn't work for most of us.
Just delete the instance using "MySQL Server Instance Config Wizard" and recreate it.
Just be careful in supplying the password.
I would say, type the password in notepad and copy paste it.

Good Luck!!!

No comments: