Getting MySQL ERROR: 1045

[prasadbabu]

Hi Guys,

I am new to this forum. So if i made any mistake please bare with me. Soon i ll follow all the guidelines as days pass through.

I am getting following error when i try to login to mysql prompt.

c:\mysql\bin>mysql -u root -p
password:*****

ERROR 1045: Access denied for user 'root'@'localhost' (using password: YES)

Where am i going wrong and how to solve this?

Thanks in advance,
Prasad

[bartonc]

Hi Guys,

I am new to this forum. So if i made any mistake please bare with me. Soon i ll follow all the guidelines as days pass through.

I am getting following error when i try to login to mysql prompt.

c:\mysql\bin>mysql -u root -p
password:*****

ERROR 1045: Access denied for user 'root'@'localhost' (using password: YES)

Where am i going wrong and how to solve this?

Thanks in advance,
Prasad

This is weird.. I couldn't log in as root either. I have two accounts - one is root, one is my user name. Both have (or are supposed to have) the same password. When I tried to log in as root, it didn't work. I went back into admin using my user name and password to reset my root password. Now it works just fine.

[ronverdonk]

This is weird.. I couldn't log in as root either. I have two accounts - one is root, one is my user name. Both have (or are supposed to have) the same password. When I tried to log in as root, it didn't work. I went back into admin using my user name and password to reset my root password. Now it works just fine.

I don't know the reason for you both having this problem, but I certainly do not have it! My private userid and the 'root' userid have identical passwords and I
can logon to each of those id's without problems.
So both of you must have set different passwords for your root and private userid's when you configured your server.
I cannot think of any other reason, except for some (Irish) leprechaun, who'd love to do just that.

Ronald :cool:

[colinB]

Hi guys,

New here.

Had the same problem, this saved me -
http://www.fixya.com/support/t840251...error_messeage

Good luck,
Col.