Tim, Saturday, October 12, 2002, 1:21:59 AM, you wrote: TJ> I am attempting to delete a table from a database, TJ> then recreate it and load data into the table. TJ> The drop and create commands are working properly, TJ> here's a screen dump:
TJ> mysql> DROP TABLE IF EXISTS testthis; TJ> Query OK, 0 rows affected (0.16 sec) TJ> mysql> CREATE TABLE testthis(ID INT DEFAULT '0',Reviews CHAR (50),Date DATE,Bookmark CHAR (50), TJ> -> Title CHAR (90),Web_Page CHAR (50)); TJ> Query OK, 0 rows affected (0.16 sec) TJ> mysql> LOAD DATA INFILE "/home/http/run/isak/wmj-new/uploaded/testthis.txt" INTO TABLE testthis; TJ> ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) TJ> The same error message is generated if I give the filename only, logging TJ> in from the working directory of the file. TJ> 1)Any ideas of what I may be doing wrong here? TJ> 2)Also, can anyone tell me where I can find a list of MySQL error codes? TJ> Understanding more of what ERROR 1045 is about might be helpful User must have FILE privilege to use LOAD DATA INFILE. -- 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
