470,635 Members | 2,087 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,635 developers. It's quick & easy.

Getting MySQL ERROR: 1045

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
Jan 16 '07 #1
3 33110
bartonc
6,596 Expert 4TB
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.
Jan 16 '07 #2
ronverdonk
4,258 Expert 4TB
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:
Jan 17 '07 #3
colinB
1
Hi guys,

New here.

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

Good luck,
Col.
Jul 27 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Morten Gulbrandsen | last post: by
reply views Thread by Ike_strong | last post: by
3 posts views Thread by karonte | last post: by
3 posts views Thread by dstewart | last post: by
reply views Thread by baghath | last post: by
1 post views Thread by Korara | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.