mysql-readers,
Thursday, May 30, 2002, 1:31:50 PM, you wrote:
EE>> Yeah, "Access denied" error means that user doesn't have necessary
EE>> permissions. Can you provide some more info? i.e. full error
EE>> message, how did you set up file_priv using GRANT statement or
EE>> updated privilege tables manually? What version MySQL client and
EE>> server do you use?
mr> I thought I included full details in the transcript attached, but here
mr> are your questions answered too because I am keen to resolve this :)
There was no attached transcript.
mr> Yes, I set them up using "GRANT" and tried doing some table tweaking
mr> too, used "flush privileges" lots of times "just to make sure" ;) and
mr> I am using MySQL v3.23.36 installed from RH's RPMs with the
mr> corresponding client package so I can do command-line testing
mr> interactively IYSWIM. It's all on a RH Linux box, but I have it
mr> installed on a number of OS's so that's prolly not very relevant. The
mr> Server has been running for ages without the slightest hint of any
mr> other problem.
mr> I must have a privilege wrong somewhere, but it appears to be exactly
mr> right -- here's what I get in response to a SHOW GRANTS command: -
mr> mysql> show grants for fileuser@localhost;
mr>
+---------------------------------------------------------------------------------------+
mr> | Grants for fileuser@localhost
|
mr>
+---------------------------------------------------------------------------------------+
mr> | GRANT FILE ON *.* TO 'fileuser'@'localhost' IDENTIFIED BY PASSWORD
'9999999999999999' |
mr> | GRANT SELECT ON test2.product TO 'fileuser'@'localhost'
|
mr>
+---------------------------------------------------------------------------------------+
mr> 2 rows in set (0.00 sec)
mr> And the SELECT statement that doesn't work is as follows: -
mr> mysql> SELECT partno, descrip, cost INTO OUTFILE '/tmp/jj'
mr> FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
mr> FROM product limit 10;
mr> ERROR 1044: Access denied for user: 'fileuser@localhost' to database 'test2'
Hmm. It works fine for me. Can you send me dump of your database
'mysql' for testing?
mr> Crazy, huh?!?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
