By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,133 Members | 1,092 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,133 IT Pros & Developers. It's quick & easy.

Getting MySQL ERROR: 1045

P: 5
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
Share this Question
Share on Google+
3 Replies


bartonc
Expert 5K+
P: 6,596
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
Expert 2.5K+
P: 4,258
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

P: 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.