MySQL Forums
Forum List  »  General

need the RELOAD privilege for this operation?
Posted by: Magnus Bjorkman
Date: September 13, 2006 12:50PM

Hi,

I hava 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 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 Admin (as root) to giv all priv to this user for both myDB and mysql, but I got the same response.

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

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

TIA

Options: ReplyQuote


Subject
Written By
Posted
need the RELOAD privilege for this operation?
September 13, 2006 12:50PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.