At 4:50 PM -0700 5/1/01, Dato wrote:
>how does a user set his own password in mysql? I have searched
>through the archives, and have found only the 'st password..'
>command. this does not work. In my case, there are more then just
>one host in the user table and the set password command only changes
>the localhost entry, leaving me unable to connect with the new
>password form other hosts! how do I solve this? Any help would be
>appreciated. Thanks.
Unless you're the root user, you can only change the password of the user
that you're connected as. Allowing you change someone else's password would
be a huge security breach. (The user table entries you refer to *are* for
different users, because a "user" in MySQL is really a user+hostname
combination.) You'll need to connect with the given user name from
the
various hosts to be able to change the corresponding passwords with the
SET PASSWORD command.
--
Paul DuBois, [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php