ERROR 1045 (28000): Access denied

[ajd335]

Hi all...

I am working with PHP and mysql. I have one form from which i am importing data into the table.
Now i want "email " field result into a text file
I am using code
[code=sql]

select email from table_1 into outfile '/location/result.txt';

[/Code]

but when i run that query ,it gives me that error..ERROR 1045 (28000): Access denied error....and whether it is a right query or not...plz help me

[ck9663]

Try posting in MySQL forum.

If you can run the query and the error is access denied, I'd say the credentials that's trying to create the text file does not have the necessary rights.

-- CK