Egor,
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?
I thought I included full details in the transcript attached, but here
are your questions answered too because I am keen to resolve this :)
Yes, I set them up using "GRANT" and tried doing some table tweaking
too, used "flush privileges" lots of times "just to make sure" ;) and
I am using MySQL v3.23.36 installed from RH's RPMs with the
corresponding client package so I can do command-line testing
interactively IYSWIM. It's all on a RH Linux box, but I have it
installed on a number of OS's so that's prolly not very relevant. The
Server has been running for ages without the slightest hint of any
other problem.
I must have a privilege wrong somewhere, but it appears to be exactly
right -- here's what I get in response to a SHOW GRANTS command: -
mysql> show grants for fileuser@localhost;
+---------------------------------------------------------------------------------------+
| Grants for fileuser@localhost
| |
+---------------------------------------------------------------------------------------+
| GRANT FILE ON *.* TO 'fileuser'@'localhost' IDENTIFIED BY PASSWORD
|'9999999999999999' |
| GRANT SELECT ON test2.product TO 'fileuser'@'localhost'
| |
+---------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
And the SELECT statement that doesn't work is as follows: -
mysql> SELECT partno, descrip, cost INTO OUTFILE '/tmp/jj'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
FROM product limit 10;
ERROR 1044: Access denied for user: 'fileuser@localhost' to database 'test2'
mysql>
Crazy, huh?!?
--
Best regards,
James.
---------------------------------------------------------------------
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
