need the RELOAD privilege for this operation?
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
Subject
Written By
Posted
need the RELOAD privilege for this operation?
September 13, 2006 12:50PM
September 13, 2006 01:06PM
September 14, 2006 03:59PM
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.