Re: LOAD_FILE and PHP
| From: | Jough P | Date: | Fri, 16 Jan 2004 22:08:23 +0000 |
| Subject: | Re: LOAD_FILE and PHP | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-174891@lists.php.net to get a copy of this message | ||
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: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.phpGreetings 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.