At 2:16 +0000 8/13/02, LR P wrote:
>hi all,
>
>
>i have a problem with "load data..." statement. i'm using MySQL 
>3.23.49 from RedHat 7.3. i read Paul DuBois book about MySQL, and 
>tried to load data to my member table,
>mysql> LOAD DATA INFILE "member.txt" INTO TABLE member;
>but i didn't work.

What was the error with LOCAL included?

>
>i've tried by removing the 'local', but it gave me same error message,
>ERROR 1045: Access denied for user: 'ihot@localhost' (Using password: YES)

When you remove LOCAL, then the file must be read by the server, in which
case you need the FILE privilege.

>
>i've given permission to user 'ihot' (from root), by using:
>mysql> GRANT ALL ON samp_db.* TO ihot@localhost IDENTIFIED BY "*******"

You'll need GRANT FILE ON *.* TO ihot@localhost; to give yourself
the FILE privilege.

>
>but still, it didn't work...
>
>Any idea, guys?


---------------------------------------------------------------------
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