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
/ /|_/ / // /\ \/ /_/ / /__ Egor.Egorov@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
