Honesty Rocks! truth rules.

Mysql And User File_priv

HOME      >>       Programming

rockarolla

HI,I've hit the grain while trying to import file to mysql database - I need to enable file permissions of the database user but this seems not possible with most of the hosting providers. The problem is to set file_priv of the database user to "Y" . This is done in the "user" table of the maintanance database named "mysql". cPanel doesn't allow this. Via the cPanel you can only allow privileges on table querries but you cannot grant host file privileges to the database user - which makes querries like:"LOAD DATA INFILE 'filename' INTO TABLE tablename..."impossible to use - you'll get the access denied errors ...Any workaround will be greatly appreciated!