HOME       >>       Programming

Mysql And User File_priv


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!


Xisto.com offers Free Web Hosting to its Members for their participation in this Community. We moderate all content posted here but we cannot warrant full correctness of all content. While using this site, you agree to have read and accepted our terms of use, cookie and privacy policy. Copyright 2001-2019 by Xisto Corporation. All Rights Reserved.