VINOD, Saturday, July 27, 2002, 6:57:04 AM, you wrote:
V> Subsequently I have loaded above codings V> (post_data.php) on the web and the product.txt file V> into the /tmp directory which is available on web. V> This /tmp directory is having read, write, delete, V> execute permissions. Now the error is V> I am able to display the content of the table count on V> the screen. When it is executing the load query, it is V> showing the error on the browser that V> COUNT=006 V> Access denied for user:root@localhost (Using Passwor- V> dYES) V> Please suggest me how to over come the problem If you load data from server host with LOAD DATA statement you must have FILE privilege. It's a global privilege. http://www.mysql.com/doc/P/r/Privileges_provided.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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