Forum Topics : Support / Problem uploading csv to MySQL
I have tried following the many suggestions in the handbook to upload the csv file, and each time I have a different error.
I am using the PHPMyAdmin import utility, and selecting CSV using LOAD DATA, then I set:
Fields terminated by: ,
Fields enclosed by: "
Fields escaped by: (blank)
Lines terminated by: \r\n
Use LOCAL keyword: (not checked)
I select the csv file using the BROWSE button to select the csv file from my local filesystem.
Then I hit go, and eventually get the following error back:
#1045 - Access denied for user 'xyz'@'localhost' (using password: YES).
Where xyz is the username for the database.
Has anyone else had similar experiences, or found a way to import the csv file with this import tool?
I am using the PHPMyAdmin import utility, and selecting CSV using LOAD DATA, then I set:
Fields terminated by: ,
Fields enclosed by: "
Fields escaped by: (blank)
Lines terminated by: \r\n
Use LOCAL keyword: (not checked)
I select the csv file using the BROWSE button to select the csv file from my local filesystem.
Then I hit go, and eventually get the following error back:
#1045 - Access denied for user 'xyz'@'localhost' (using password: YES).
Where xyz is the username for the database.
Has anyone else had similar experiences, or found a way to import the csv file with this import tool?
