On Fri, 5 Mar 2004, Paul DuBois wrote:
> At 18:10 +0100 3/5/04, Bogdan Lobodzinski wrote:
> >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?
mysql> SELECT CURRENT_USER();
+--------------------+
| CURRENT_USER() |
+--------------------+
| dummy@<host_ip> |
+--------------------+
1 row in set (0.01 sec)
user dummy@<host_ip> is exactly the same like in the ERROR outoput.
I just noticed small mistake in the ERROR output. The proper one is:
mysql> set password=password('testpass1');
ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'mysql'
Cheers,
Bogdan
> --
> 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]
