By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,378 Members | 1,385 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,378 IT Pros & Developers. It's quick & easy.

ERROR 1045 (28000): Access denied

P: 123
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
Expand|Select|Wrap|Line Numbers
  2.  select email from table_1 into outfile '/location/result.txt';
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
May 9 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 2,878
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
May 9 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.