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
