On Wed, 21 Nov 2001 17:02:29 -0500, Christopher Book <[EMAIL PROTECTED]>   wrote:

>>>>UPDATE Software SET Description =
>>LOAD_FILE(/usr2/home/khan/www/cgibin/protecting/Describe/description_file)
>>WHERE ID = 9 
>>
>>You have to make sure that not only can mysql read the file, but it also has
>>permissions to the directories that the files are in.  Typically your home
>>directory on your server may not be world readable, but for mysql to access
>>it, it must be.
>>
>>Chris

Plus I believe you have to have FILE privileges enabled in the mysql.user table.
I had a similar problem with a client, and after granting FILE privileges, it
worked perfectly! :)


Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to