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

What is the privelige of the directory??


--
                 ______      
 _______/ Chuck   \_________
|                                               |
|     www.aa8vs.org/aa8vs       |
================================
The pessimist complains about the 
wind; the optimist expects it to 
change; the realist adjusts the 
sails."
    -- William Arthur Ward


 -------------- Original message ----------------------
From: Bjorkman <[email protected]>
> 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]
> 



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