MySQL File Privilege

[Gina]

I have written a PHP Script that uploads a file. The file must then replace data in a MySQL Table using Load Data Infile.

The file uploads, is moved to the proper directory and then I am receiving a Permission denied error on the load data infile command.

Everything I have read says that there needs to be file privileges so that this can be done.

What I want to do and does not work is:

grant select, insert, update, delete, file, index
on database.*
to user@localhost identified by 'password';

If I grant total access, like this, the load data infile works:
grant all
on *
to user@localhost identified by 'password';

I only want this user to have access to one database and not every database on the server.

Does anyone have any ideas or is there another way to do this?

[hand]

Originally posted by Gina
grant select, insert, update, delete, file, index
on database.*
to user@localhost identified by 'password';

Does the database with the name "database" really exist, or is this only a sample? Are you sure that you are connectetd with a user which name is "user", or is this only a sample too?

What happens if you are granting as follows:

grant select, insert, update, delete, file, index 
on * 
to user@localhost identified by 'password';

All about GRANT http://www.mysql.com/doc/en/GRANT.html

[Gina]

database is a sample database name and user is a sample user name.

I know that I am connecting to the database because I ran a delete from tablename; and my data did get deleted.

I tried the example that you posted and received a permission denied error.