Hallo there,
I have got my first server using DA, I have just discovered that by default mysql is setup with the option local-infile=0, which means that I cannot run the query "LOAD DATA LOCAL INFILE...".
So my question is: how can I make php scripts work to load files into tables?
I have read the old thread about the security issue when root tests the query LOAD DATA LOCAL INFILE to read password files, but I would like to understand if there are other ways to load files from a webpage or if it is supposed, and correct, that I have to remove such configuration to start using mysql LOAD DATA LOCAL INFILE.
I have also see that by default mysql users have the file permission set to off, so no user can read files to import.
Also here, I have not understood if when the file to import is located into the server LOAD DATA INFILE (without LOCAL) could work or not.
Reading at the mysql documentation it seems possibile with such user option turned on, but when I try to execute I always get the error
ERROR 1045 (28000): Access denied ...
Can anybody explain me how I have to setup my server to be able to run LOAD DATA (LOCAL) INFILE from my php scripts?
thanks a lot
Fabio
I have got my first server using DA, I have just discovered that by default mysql is setup with the option local-infile=0, which means that I cannot run the query "LOAD DATA LOCAL INFILE...".
So my question is: how can I make php scripts work to load files into tables?
I have read the old thread about the security issue when root tests the query LOAD DATA LOCAL INFILE to read password files, but I would like to understand if there are other ways to load files from a webpage or if it is supposed, and correct, that I have to remove such configuration to start using mysql LOAD DATA LOCAL INFILE.
I have also see that by default mysql users have the file permission set to off, so no user can read files to import.
Also here, I have not understood if when the file to import is located into the server LOAD DATA INFILE (without LOCAL) could work or not.
Reading at the mysql documentation it seems possibile with such user option turned on, but when I try to execute I always get the error
ERROR 1045 (28000): Access denied ...
Can anybody explain me how I have to setup my server to be able to run LOAD DATA (LOCAL) INFILE from my php scripts?
thanks a lot
Fabio