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

I have 2 machines (both XP)

MySQL 4.1 (Devlop machine)
Install      Default (C:\Program Files\MySQL)
DataFiles    H:
Client installed on F: drive  (same machine)
QB           Default
No dirs are shared
Running as Admin

MySQL 5.0 (remote machine over LAN)
Install      Default (C:\Program Files\MySQL)
DataFiles    Default (C:\...)
QB           Default
Client installed on remote machine (machine above)
No dirs are shared
Running as Admin (QB on machine and Client remotely)

Magnus

--- [email protected] wrote:

> 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]
> 
> 


__________________________________________________
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]