MySQL Forums
Forum List  »  Newbie

Can't log in after granting priveleges from monitor
Posted by: Donnie Karns
Date: August 11, 2005 12:24PM

I just downloaded phpdev4.2.3 this morning. My problem is that I can't log in using the username and pass I created in mySql monitor in DOS. Here are the lines used:

GRANT ALL
ON dbName.*
TO user identified by 'pass123';

I then type 'Quit'.

I then type 'mysql -u user -p'

After being prompted for password, I type 'pass123'

The system beeps and I get this error:
ERROR 1045 (HY000): Access denied for user: 'user@127.0.0.1' (Using password: YES)

Also, I have to navigate to the mysql.exe file in DOS to start the monitor (I used to be able to type 'mysql' at any time in DOS and get to the monitor when I manually installed Apache, mySQL, and the rest).

Any thoughts? If you need more information, I'll gladly deliver. Thank you!

--Donnie

Options: ReplyQuote


Subject
Written By
Posted
Can't log in after granting priveleges from monitor
August 11, 2005 12:24PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.