Missing Privileges but can't figure out what to do?

Hi,

I have a Java App where users can be added to the
system (and the MySQL DB). In one window I let the
user change the password (for themselves) but get the
following error:
---
SQLState: 42000
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException:
Access denied; you need the RELOAD privilege for this
operation    
---
I then used the MySQL Administrator (as root) to give
all priv to this user for both myDB and mysql, but I
got the same response.

SQL stmt that fail:
-------------------
stmt.executeUpdate("UPDATE mysql.USER " +
" SET PASSWORD = PASSWORD(\'" + user[2] + "\') "+
" WHERE USER = \'"+user[0] +"\' ");

stmt.executeUpdate("FLUSH PRIVILEGES");

i.e.
---- 
UPDATE mysql.user set password = password('newpwd')
where user = 'magnus';
FLUSH PRIVILEGES;

NOTE: I reproduce this on MySQL QueryBrowser (ErrorNr:
1227) but it works from the console?

MySQL QueryBrowser:
select * from mysql.user; --> all *_priv was set to
'N'
SHOW GRANTS --> I have ALL PRIV on mydb.* AND mysql.*


MySQL Administrator: show I have all privileges?

There is no PRELOAD priv to set?

I use:
mysql-5.0.24-win32.zip
mysql-connector-java-5.0.3-bin.jar

I also tried this on: mysql-4.1.8 with JDBC-3.1.10 and
got same problem

WHAT AM I MISSING???

Magnus

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]