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?
--
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]
