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