2

I need help. When I try this - SELECT * FROM .. INTO OUTFILE - on local, everything is ok. When I try it on my hosting, I receive error message #1045 - Access denied for user '..'@'%' (using password: YES) . How to do it make it work? Thanks for any advice :)

Martin Prikryl
  • 167,268
  • 50
  • 405
  • 846
Honza Hála
  • 87
  • 1
  • 8
  • Ask your host provider, they might not allow this functionality or it might be just a missing/wrong configuration. – Szabolcs Páll Aug 26 '15 at 07:32
  • Provider I asked first of all, but he don't know nothing, and SELECT feature is enabled. I try to perform an action through the admin account. – Honza Hála Aug 26 '15 at 07:56
  • 2
    possible duplicate of [MYSQL into outfile "access denied" - but my user has "ALL" access.. and the folder is CHMOD 777](http://stackoverflow.com/questions/6091427/mysql-into-outfile-access-denied-but-my-user-has-all-access-and-the-fold) – Szabolcs Páll Aug 26 '15 at 09:01

1 Answers1

0

I finally solved the problem by using fputcsv() - simply by using the SELECT, from the database i take field up and in the PHP script I created CSV file :)

Honza Hála
  • 87
  • 1
  • 8