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. 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) i've given permission to user 'ihot' (from root), by using: mysql> GRANT ALL ON samp_db.* TO ihot@localhost IDENTIFIED BY "*******" but still, it didn't work... Any idea, guys? Thanx 4 your help..... _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.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