Hello,
All users should be able to change their own password on any mysql.
I have trouble to allow this feature on mysql 4.0.12, on mysql 3.23.56 it works.
Let me demonstrate it: on mysql 3.23.56: as root: -------- mysql> create database test_dummy; Query OK, 0 rows affected (0.00 sec) mysql> grant all on test_dummy.* to dummy; Query OK, 0 rows affected (0.00 sec) mysql> set password for 'dummy'=password('testpass'); Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.01 sec) mysql> exit Bye --------- as a user: dummy: --------- mysql> set password=password('testpass1'); Query OK, 0 rows affected (0.01 sec) --------- so user 'dummy' can change private password. This is what I need.
now the same operations on mysql 4.0.12: as root: -------- mysql> create database test_dummy; Query OK, 0 rows affected (0.00 sec) mysql> grant all on test_dummy.* to dummy; Query OK, 0 rows affected (0.00 sec) mysql> set password for 'dummy'=password('testpass'); Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.01 sec) mysql> exit Bye -------- and as a user: dummy: -------- mysql> set password=password('testpass1'); ERROR 1044: Access denied for user: 'dummy@'<host_ip>' to database 'mysql' --------
User dummy cannot change his own password ... Any idea how to change it ? Or some hints where is a my mistake ?
On the 4.0.12 machine, what does SELECT CURRENT_USER() return?
-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]