Re: SOLVED - LOAD_FILE and PHP

Thank you everyone for you fabulous help!!! btw, the FILE privilege is a global privilege, and as such needs to be in the *.* context. It does not work on a db-level. On Jan 16, 2004, at 4:08 PM, Jough P wrote:

OMG I'm sure that's why I'm having problems. Do you know the syntax for granting the file_priv? The following doesn't seem to work: mysql> GRANT file ON bs.table1 TO bsuser@localhost 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