Setting Passwords
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
Subject
Written By
Posted
Setting Passwords
July 01, 2005 06:46PM
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.