Amit,
Friday, April 26, 2002, 11:57:28 AM, you wrote:
AL> Can someone help me figure out the following problem.
AL> If i fire the following command from
D:\mysql\bin>> mysql --user=netaps --password=netaps
AL> --host=192.168.100.2 --port=3306 --database=netaps
AL> --execute="LOAD DATA INFILE
AL> 'D:\\NetapsFiles\\jobsequence.csv' INTO TABLE
AL> jobsequence FIELDS TERMINATED BY ','";
AL> It generates the following error:-
AL> ERROR 1045: Access denied for user
AL> netaps@NETAPS1(Using Password: YES)
AL> but now if i executete command as :-
AL> mysql --user=netaps --password=netaps
AL> --host=192.168.100.2 --port=3306 --database=netaps
AL> --execute="select count(*) from jobbatch";
AL> It works fine.
To use LOAD DATA INFILE your user must have file privilege on the
server host. Look at:
http://www.mysql.com/doc/L/O/LOAD_DATA.html
http://www.mysql.com/doc/P/r/Privileges_provided.html
AL> Plase Help
AL> REgards
AL> Amit
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [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
