10 messages in com.mysql.lists.mysqlRE: load data infile question| From | Sent On | Attachments |
|---|---|---|
| Salada, Duncan | 21 Mar 2003 10:41 | |
| Jeff Kilbride | 21 Mar 2003 16:17 | |
| Victoria Reznichenko | 24 Mar 2003 06:05 | |
| Salada, Duncan | 24 Mar 2003 08:07 | |
| Salada, Duncan | 25 Mar 2003 09:53 | |
| Mark | 25 Mar 2003 12:14 | |
| Jeremy Zawodny | 25 Mar 2003 12:18 | |
| Stefan Hinz | 25 Mar 2003 12:20 | |
| Victoria Reznichenko | 26 Mar 2003 03:54 | |
| Salada, Duncan | 26 Mar 2003 05:30 |
| Subject: | RE: load data infile question |
|---|---|
| From: | Salada, Duncan (Dunc...@titan.com) |
| Date: | 03/24/2003 08:07:40 AM |
| List: | com.mysql.lists.mysql |
-----Original Message----- From: Victoria Reznichenko [mailto:vict...@ensita.net] Sent: Monday, March 24, 2003 9:06 AM To: mys...@lists.mysql.com Subject: re: load data infile question
Hi!
On Friday 21 March 2003 20:41, Salada Duncan wrote:
I am using MySQL 3.23.49 and have started having a problem with the "load data infile" command.
I recently created a new user with select,insert,update,and delete on one table only (tableA). Because I want the user to be able to use "load data infile" to load records into tableA, I also gave it the file privilege on a global scale (which is the only way to do it AFAIK). Yet when I attempt to use "load data infile FILE into tableA" after having connected using the mysql client, I get an access denied message. Is there something else I need to do?
Some other pertinent info... - Yes, I have flushed privileges after giving privileges - I know "load data infile" works (in general) because I have another user that could do it without any trouble.
You must have FILE privilege to use LOAD DATA INFILE. Do you have this privilege?
Yes, I have the FILE privilege.
Duncan
----------------------------------------------- Duncan Salada Titan Systems Corporation 301-925-3222 x375