Hi guys,
I am using phpMyAdmin 2.4 and recently my web host changed my IP, so I went to config.inc.php and changed my $cfg['Servers'][$i]['host'] accordingly, because it used to have my old IP. Now, I can do perform sqls and export db, but every time I try to insert data from csv file I get this error:
Error
SQL-query :
LOAD DATA INFILE '/tmp/phpFcc4u8' REPLACE INTO TABLE `retailerInfo`
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\r\n'
MySQL said:
Access denied for user: 'webtekie@webmacaco.com' (Using password: YES)
Why do I get this error? Should I not have changed my IP manually in config.inc.php but somewhere so it takes affect globally?
Also, is there another MySQL Admin tool that I can use?
thanks a lot,
webtekie