Mysql Import Issue - Rights

[hbcrosby]

I am trying to import a .csv file into an new MySql table within an existing DB using phpMyAdmin. I created the table using phpMyAdmin.

 

I have performed this task a few times in the past successfully, but for some reason I can't on this new table. Here is the error I'm receiving:

 

#1045 - Access denied for user: 'harvest@localhost' (Using password: YES)

 

Here is the test file I'm trying to import:

 

1,12/15/2005,morrison,crosby,godwin,ariel,matt

 

 

I'm confused as I am logged in as Admin for the site, I can insert info using phpMyAdmin, but it seems that phpMyAdmin is not recognizing me when I try to import a text file.

 

Anybody have an idea on what I am missing here? Maybe I need another cup of coffee this morning.......

[TCH-Bruce]

Welcome to the forums!

 

Have you added the user to the database?

[hbcrosby]

Welcome to the forums! 

 

Have you added the user to the database?

<{POST_SNAPBACK}>

 

Thanks! I'm glad to be here.

 

Well,.....I believe the user has been added to the DB. What I'm actually trying to do is add a table to an existing DB. Through phpMyAdmin, I created the table and the fields. I would think that this action would not work if I didn't have the correct rights. I can add data if I use phpMyAdmin, but I can't add data when I import a text file through phpMyAdmin.

 

I've done this type of import several times previously with this DB. I'm a little confused on why I can't import this time.

 

Any advice would sure be appreciated!

[borfast]

Welcome to the family, hbcrosby!

 

Are you sure you're using the correct database name and username? The database name should be in the form of "yourcpanelusername_databasename" and yourusername in the form of "yourcpanelusername_database_username".

 

That's a common mistake when people are not used to this kind of nomenclature.