List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:February 5 2000 8:28pm
Subject:Re: Import Problem
View as plain text  
At 2:55 PM -0500 2000-02-05, Mark Allen wrote:
>----- Original Message -----
>From: Paul DuBois <paul@stripped>
>
>>  At 12:29 PM -0500 2000-02-05, Mark Allen wrote:
>>  >I'm brand new to MySQL & I'm trying to create a new table using an
> input
>>  >file but I'm running into problems. The input file creates the table and
>the
>>  >following lines insert the data:
>>  >
>>  >CREATE TABLE employees (  id tinyint(4) DEFAULT '0' NOT NULL
>AUTO_INCREMENT,
>>  >[snip]
>>  >INSERT INTO employees VALUES (2,'John','Roberts','45 There St ,
>>  >Townville','Telephonist');
>>  >  and so on.
>>  >
>>  >However when I try to to this I get the following:
>>  >
>>  >[12:13:18] mark:~/notes$ mysql -u mark -p bib < mydb.dump
>>  >Enter password:
>>
>>***************************************************************************
>*
>>  >***
>>  >ERROR 1045: Access denied for user: 'mark@localhost' (Using password:
>YES)
>>
>>  First you need to try simply to see if you can connect to the MySQL
>>  server:
>>  $ mysql -u mark -p
>>  Enter password:
>>
>>  Then enter the password.  I assume this will fail with the same error
>>  you get above.  In that case you should contact your MySQL administrator
>>  to find out what your password is supposed to be.
>
>No, that's not the problem at all; I'm the administrator and I've been
>creating tables, deleting rows and other fun things for a few days. MySQL is
>set up properly  and
>$ mysql -u mark -p bib
>works fine. The problem is that I cannot import data in the manner specified
>above. Is there an alternative way to import large sets of data?


If mysql -u mark -p bib works fine, then if you manually enter the statements
above, do they work?  If not, you simply don't have permission to create
tables in the bib database.

-- 
Paul DuBois, paul@stripped
Thread
Import ProblemMark Allen5 Feb
  • Re: Import ProblemPaul DuBois5 Feb
  • Re: Import ProblemMark Allen5 Feb
    • Re: Import ProblemPaul DuBois5 Feb
  • Re: Import ProblemMark Allen5 Feb
  • Re: Import ProblemPaul DuBois6 Feb