Are we able to use the LOAD DATA INFILE MySQL function?

Discussion in 'Scripts, 3rd Party Apps, and Programming' started by eetoolsx, Jul 22, 2014.

  1. eetoolsx

    eetoolsx New Member

    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    "LOAD DATA INFILE '$myFile'" .
    " INTO TABLE test FIELDS TERMINATED BY ','"

    I always get an error that says: "Could not load. Access denied for user 'eetoolsx'@'localhost' (using password: YES)"

    Do they prevent us from useing the LOAD DATA INFILE ?
     
  2. leafypiggy

    leafypiggy Manager of Pens and Office Supplies Staff Member

    Messages:
    3,819
    Likes Received:
    162
    Trophy Points:
    63
    Your username is most likely wrong. It should be something like eetoolsx_<username>
     
  3. tstingr5

    tstingr5 New Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    I have the same problem, I think is the FILE privileged, please, annyone have an answer or advice?
    Access denied for user 'tstingr5_admin'@'localhost' (using password: YES)
     
  4. eetoolsx

    eetoolsx New Member

    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    I got it to work using "load data local infile" syntax.
     

Share This Page