Hi
I have problem with passwords.
Normal users who have only 'USAGE' global privileges are
not able to change their own password. I tried to do fresh installation
of mysql 4.0.9 (and 4.0.8) on my windows workstation. I created new user
(as root):
GRANT USAGE ON *.* TO dummy@localhost;
then I logged in as 'dummy' (mysql -u dummy) and tried to change
password for dummy:
SET PASSWORD=PASSWORD('newpassword');
I got:
ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'mysql'
This functionality worked just fine with mysql 3.23.54. and 3.23.55.
What kind of privileges normal user needs in order to change his/her own
password?
Teemu Kuulasmaa
---------------------------------------------------------------------
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