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

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

am 14.09.2006 16:59:10 von Bjorkman

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/win32?unsub=gcdmw-win32@m.gmane.org

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

am 14.09.2006 17:12:48 von Charles Mabbott

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
> 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/win32?unsub=crmabbott@comcast.net
>



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

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

am 14.09.2006 22:26:37 von Bjorkman

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

--- crmabbott@comcast.net 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
> > 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/win32?unsub=crmabbott@comcast.net
> >
>
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
>
http://lists.mysql.com/win32?unsub=magnus_bjorkman@yahoo.com
>
>


__________________________________________________
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/win32?unsub=gcdmw-win32@m.gmane.org