You were right. Its a global privilege not a table one. I granted it at a global level. it can't be granted at the databae level
Dan Buettner wrote: > Curtis, you might need to make sure 'admin'@'localhost' has 'FILE' > privileges in the proper database, for load data infile. Note that > 'admin'@'%' is not the same as 'admin'@'localhost' > > See http://dev.mysql.com/doc/refman/5.0/en/grant.html > > > Also here is a comment from the same page: > QUOTE > Posted by Cristian Gafton on July 17 2006 6:28pm [Delete] [Edit] > Please note that the current MySQL priviledge model does not support > creating a read-only user for an application that needs to work with > temporary tables. In other words, the 'SELECT,CREATE TEMPORARY TABLES' > privileges are not sufficient to let an application work with > temporary tables against a read-only set of tables. MySQL also > requires INSERT, DELETE and UPDATE grants to allow temporary tables to > be used. Since the temporary tables are not 'defined' at the time of > the grant, one would have no choice but to grant INSERT,DELETE,UPDATE > on db.*, which negates the possibility of a read-only user. > > It would be nice if MySQL would have a more generic 'TEMPORARY TABLES' > permission that would allow one to create, insert, delete from and > drop temporary tables without having to give up insert/update/delete > privileges on the real tables > > /QUOTE > > Dan > > > > On 8/15/06, Curtis Maurand <[EMAIL PROTECTED]> wrote: >> >> here is what I get. I'm logged in as the user admin (really a regular >> user.) >> >> mysql> create temporary table customer_tmp as select * from customer >> limit 0; >> Query OK, 0 rows affected (0.00 sec) >> Records: 0 Duplicates: 0 Warnings: 0 >> >> mysql> load data infile '/home/bluetarp/ezauth/customers.txt' into table >> customer_tmp; >> ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using >> password: YES) >> >> >> >> >> Dan Buettner wrote: >> > Or possibly that the mysql user on the box does not have access to the >> > data file in question. Can you post the error messages you get? >> > >> > Dan >> > >> > >> > On 8/15/06, Curtis Maurand <[EMAIL PROTECTED]> wrote: >> >> This may sound like a stupid question, but I have to ask. I've been >> >> running a script that goes like the following. >> >> >> >> >> >> >> >> use ecommerce; >> >> create temporary table customer_tmp as select * from customer limit >> 0; >> >> load data infile '/home/bluetarp/ezauth/customers.txt' into table >> >> \customer_tmp; >> >> >> >> at which point the script fails for permssion reasons. It seems that >> >> this >> >> user can create a temporary table, but not load data into it? >> >> >> >> What did I miss on permissions to allow this to work? >> >> >> >> Thanks >> >> Curtis >> >> >> >> >> >> -- >> >> MySQL General Mailing List >> >> For list archives: http://lists.mysql.com/mysql >> >> To unsubscribe: >> >> http://lists.mysql.com/[EMAIL PROTECTED] >> >> >> >> >> > >> > -- >> > MySQL General Mailing List >> > For list archives: http://lists.mysql.com/mysql >> > To unsubscribe: >> http://lists.mysql.com/[EMAIL PROTECTED] >> > >> >> >> > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]