On Fri, 5 Mar 2004, Paul DuBois wrote:
> At 18:38 +0100 3/5/04, Bogdan Lobodzinski wrote:
> >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'
>
>
> Do you in fact have more than one account with a username of dummy on
> the 4.0.12 machine?
no, only 1 "dummy" account exist. I just created a "dummy" user only for
tests. The problem appeared when other users tried to change the start-up password.
> --
> 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]
