Re: Missing Privileges but can't figure out what to do? - Bjorkman - com.mysql.lists.win32

3 messages in com.mysql.lists.win32Re: Missing Privileges but can't figu...

From	Sent On	Attachments
Bjorkman	14 Sep 2006 07:58
crma...@comcast.net	14 Sep 2006 08:12
Bjorkman	14 Sep 2006 13:26

Subject:	Re: Missing Privileges but can't figure out what to do?
From:	Bjorkman (magn...@yahoo.com)
Date:	09/14/2006 01:26:14 PM
List:	com.mysql.lists.win32

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

--- crma...@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 <magn...@yahoo.com>

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=crma...@comcast.net

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