On Mon, Sep 1, 2008 at 6:05 PM, Paul Saenz <[email protected]> wrote: > I should clarify what I used as a command. I'm sure some would already > assume what happened, but just to eliminate all possibility of ambiguity, > the command I posted: > > mysql> SET PASSWORD FOR ''@'localhost' = PASSWORD('newpwd'); > came from the following website: > http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html > > When I actually typed it into my command prompt, I tried it several ways. > Here are examples of how I tried it: > mysql>SET PASSWORD FOR ' '@'localhost' = Password('djnr84KF&%') > That is not really the password, but a mockup. (of course) > I also tried: > mysql>SET PASSWORD FOR 'root'@'localhost' = Password('djnr84KF&%') > and: > mysql>SET PASSWORD FOR 'paul'@'localhost' = Password('djnr84KF&%') > and: > mysql>SET PASSWORD FOR '127.0.0.1'@'localhost' = Password('djnr84KF&%')
Do a 'FLUSH PRIVILEGES' to tell mysql to reload the access tables. (Or restart the mysql service). -- Regards... Todd
