#1045 - Access denied for user

[sanderphp]

Good afternoon,

 

I'm just getting started with mySQL and had been testing some imports and queries using a hosted mySQL db and I had been learning a lot. I just registered a domain and got a host and started using it. I created a db and tables and went to do my import but I'm getting:

 

 

Error

 

SQL query:

 

LOAD DATA INFILE'/home2/woodchuc/tmp/phpoTUM64' INTOTABLE`transactions`FIELDSTERMINATEDBY',' ENCLOSEDBY'"' ESCAPEDBY'\\' LINESTERMINATEDBY'\r\n' IGNORE 6LINES (

 

`date` ,`description` ,`amount`

)

 

MySQL said:

#1045 - Access denied for user 'woodchuc'@'localhost' (using password: YES)

 

 

 

Doesn't really make any sense to me because I logged into phpadmin via the admin panel for my host and am able to create db's and tables. It doesn't give me the option to choose a user so I assume that the user that is being logged in has rights as I'm able to create db's, tables, write to the table, etc.  I can't import data though

 

I hope I'm missing something basic, been scratching my head for a while now.

 

Thanks