The documentation describes the use of "set password = password ('newpass')
as:
"PASSWORD = PASSWORD('some password')
Set the password for the current user. Any non-anonymous user can change his
own password!"
Well, nice I thought, a user can change it's password without having access
rights to mysql db as I presume.
However, when i try to do so (i tried 2 users: a 'power' user with all
privileges and a restricted user) i get the error:
"mysql> set password = password('test');
ERROR 1133: Can't find any matching row in the user table"
however, the logged on user does exist (of course), with appropiate hostname
(set to fixed ip address, not a range).
Any clue?
Sysinfo:
server: mysql v. 3.23.32 on NT4 sp6a
client: mysql v.3.23 on w2kpro sp1
---------------------------------------------------------------------
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
