MySQL Forums
Forum List  »  Newbie

Setting Passwords
Posted by: Mark Bondurant
Date: July 01, 2005 06:46PM

I was able to set the root password using mysqladmin, but I can't seem to set them from within mysql. I've tried:

update user set password = password('bliff') where user = 'bliff';

and

set password for 'bliff'@'localhost' = password("bliff');

which updates it, but still doesn't work. Interestingly, when I set the root password that way it failed, yet after I set it with mysqladmin, it worked. Lucky I didn't try it the other way around or I'd be locked out and have to reset it. What am I missing (trick question)?

Mark

Options: ReplyQuote


Subject
Written By
Posted
Setting Passwords
July 01, 2005 06:46PM
July 01, 2005 07:00PM


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.