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 ?
Thanks,
Bogdan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
