Jump to content

#1045 - Access denied for user


sanderphp

Recommended Posts

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

Link to comment
https://forums.phpfreaks.com/topic/244272-1045-access-denied-for-user/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.