mysql> GRANT file ON bs.table1 TO [EMAIL PROTECTED] IDENTIFIED BY 'password123';
On Jan 16, 2004, at 3:15 PM, Jason Wong wrote:
On Saturday 17 January 2004 03:44, Jough P wrote:On Jan 16, 2004, at 9:12 AM, Jough P wrote:Greetings all, I can't get LOAD_FILE to work in an INSERT statement
from PHP. The generated sql works when you're in mysql but won't work
from PHP.
Are you using the same user in both cases? The use of LOAD_FILE() requires
that the user has the 'FILE' privilege.
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
------------------------------------------
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-general
------------------------------------------
/*
If God hadn't wanted you to be paranoid, He wouldn't have given you such
a vivid imagination.
*/
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
