On Friday, Oct 11, 2002, at 15:21 America/Phoenix, Tim Johnson wrote:
> 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 In Unix systems the mysql user needs file privileges to file to be loaded. It's probably simplest to have the file located on a local disk (not network shared) with privileges for all to read. -- Clayburn W. Juniel, III Phone: (602) 326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.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
