sanderphp Posted August 8, 2011 Share Posted August 8, 2011 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.