I'm asking on behalf of someone; I don't have access to the
machine in question:
How do you change your own password in MySQL 3.23.58, without
access to the mysql table?
The user in question discovered that he was only able to change
the password from the particular machine he was logged in from,
not for 'user'@'%'.
I see that the docs say that the "SET PASSWORD FOR" format is
possible only for clients with access to the mysql table. But
when the user logged into machine 'server1' and issued "SET
PASSWORD = PASSWORD('newpassw0rd')", he set the password for
[EMAIL PROTECTED] only, not for [EMAIL PROTECTED],
[EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], etc.
Is there any way he can do this, or does he need an admin
to issue a "SET PASSWORD FOR" command?
Thanks. I didn't see this raised on the mailing lists
recently, or in Paul's book, but I'd think it would be
something people would want to do fairly commonly.
Jesse Sheidlower
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
