Mysql OUTFILE- need to change user rights

Discussion in 'H-Sphere Shared Hosting' started by DBurroughs, Jan 5, 2009.

  1. DBurroughs

    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?



Share This Page

JodoHost - 26,000 hosting end-users in 100 countries
Plesk Web Hosting
VPS Hosting
H-Sphere Web Hosting
Other Services