LOAD DATA INFILE

Discussion in 'Scripts, 3rd Party Apps, and Programming' started by tstingr5, Aug 1, 2014.

  1. tstingr5

    tstingr5 New Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    I've been trying to use a script on php to export data from a csv file to my database but I always get the error: Access denied for user 'tstingr5_admin'@'localhost' (using password: YES), I think could be the FILE privileged that I don't have activated and I can't activate it.

    I'd like a solution for this issue or at least an advice, I've made a backup from my database on localhost and exported it directly from phpmyadmin to my domain, it's one of solutions for now.

    P.D. The password is correct in the php script, I've read the MySQL documentation.
     
  2. descalzo

    descalzo Grim Squeaker Community Support

    Messages:
    9,375
    Likes Received:
    327
    Trophy Points:
    83
    I am not sure, but I would guess that the FILE privilege would be a huge security hole on a shared server and would therefore be disabled.
     
    Last edited: Aug 1, 2014
  3. descalzo

    descalzo Grim Squeaker Community Support

    Messages:
    9,375
    Likes Received:
    327
    Trophy Points:
    83

Share This Page