DBurroughs
Guppy
This is probably an easy one, but I'm stumped just the same.?(
I have a SQL statement that is going out to a delimited file via OUTFILE.
I get an error, and below is what MySQL's site says:
"If you are able to connect to the MySQL server, but get an Access denied message whenever you issue a SELECT ... INTO OUTFILE or LOAD DATA INFILE statement, your entry in the user table does not have the FILE privilege enabled. "
I tried updating the user file directory, to change my rights from USAGE to FILE, but i was (rightly) denied access.
In short, how do I do this through the control panel/phpadmin?
Thanks,
DAB
I have a SQL statement that is going out to a delimited file via OUTFILE.
I get an error, and below is what MySQL's site says:
"If you are able to connect to the MySQL server, but get an Access denied message whenever you issue a SELECT ... INTO OUTFILE or LOAD DATA INFILE statement, your entry in the user table does not have the FILE privilege enabled. "
I tried updating the user file directory, to change my rights from USAGE to FILE, but i was (rightly) denied access.
In short, how do I do this through the control panel/phpadmin?
Thanks,
DAB