MySQL Bugs: #16215: set password

Bug #16215	set password
Submitted:	5 Jan 2006 8:08	Modified:	5 Jan 2006 12:49
Reporter:	mkysoft sofware	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.1.4	OS:	Windows (Windows XP with all updates)
Assigned to:	MySQL Verification Team	CPU Architecture:	Any

Description:
user can not change its own password. In old version it can be.
when execute this SQL:
set password=password('newpassword')

its give an error:
user hasn't got privilage for mysql.user table.

How to repeat:
allways

Sorry, but isn't it a duplicate of bug #16214 you just added?

It's like seem but different. One of is give an privilage error, the other one is crushes mysql.
Sorry, I think like this.

I was unable to repeat the behavior reported:

C:\mysql\bin>mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 5.1.4-alpha-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create user "miguel"@"localhost";
Query OK, 0 rows affected (0.00 sec)

mysql> set password for "miguel"@"localhost" = password("tester");
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye

C:\mysql\bin>mysql -umiguel -ptester
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 5.1.4-alpha-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> set password for "miguel"@"localhost" = password("tester2");
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye

C:\mysql\bin>mysql -umiguel -ptester2
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 5.1.4-alpha-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> exit
Bye

C:\mysql\bin>mysql -umiguel -ptester
ERROR 1045 (28000): Access denied for user 'miguel'@'localhost' (using password: YES)

C:\mysql\bin>