VINOD, Saturday, July 06, 2002, 6:49:50 AM, you wrote: V> I own a domain with MySQL support. I have created a database V> \"lnet_cal\" on the web and also table \"yarntype\", using PHP Myad- V> min on the webspace and also granted all access privileges to V> user \"lnet_root\" to the database.
[skip] V> Please suggest me on how to overcome the problem. V> The script which I have loaded is as follows. V> ---------------------------------------------------------------- V> <?php [skip] V> // (c) V> $query= \"load data infile \'/home/lnet/public_html/calcutta/yarn V> type.txt\' into table yarntype fields terminated by \',\' \" ; V> mysql_query($query) or V> die(mysql_error()); V> // THE ABOVE QUERY HAD DISPLYED THE ERROR AS FOLLOWS V> // \"Access denied for user: \'lnet_root@localhost\' (Using pass V> word: YES)\" You must have FILE privilege to use LOAD DATA INFILE. FILE privilege is a global privilege, but you set up for your user only privileges on the database. GRANT FILE ON *.* TO 'user_name'@'host_name' IDENTIFIED BY 'user_password'; -- 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