Hi,

I am trying to import a csv file into MySQL using LOAD DATA INFILE. It works fine if I'm logged in as root but not as an ordinary user. I can do any other operation when logged in as the ordinary user: SELECT,DELETE, INSERT etc.

I tried granting FILE permissions to the ordinary user

GRANT FILE ON database.* TO user@localhost IDENTIFIED BY 'password'

And tried this also out of desparation

GRANT ALL ON database.* TO user@localhost IDENTIFIED BY 'password'

But it still will only let me import a CSV if I'm root.

Anybody got any ideas???

Cheers

Stew

    Make sure the file is read/writeable by the world.

      Write a Reply...