Mighty
11-20-2002, 02:35 PM
I am trying to import a .csv text file into a MySQL table.
I have SSH access through Putty and I have successfully created a new table from a SQL file yesterday.
Now I need to add to a table by importing a .csv file. I uploaded the .csv file through FTP to my account. Then I logged in using Putty and started MySQL using the same username I used for importing the SQL file.
Here's the MySQL code I used to import the .csv file:
LOAD DATA INFILE '/home/vivedco/GroupsSchoolsFinal.csv' INTO TABLE GroupsSchools FIELDS TERMINATED BY ',';
When I submit that I get an error saying access is denied:
ERROR 1045: Access denied for user: 'vivedco_wick@localhost' (Using password: YES)
vivedco_wick was the password I used just yesterday to import the SQL file.
I'm wondering why I'm getting the access denied error?
I have SSH access through Putty and I have successfully created a new table from a SQL file yesterday.
Now I need to add to a table by importing a .csv file. I uploaded the .csv file through FTP to my account. Then I logged in using Putty and started MySQL using the same username I used for importing the SQL file.
Here's the MySQL code I used to import the .csv file:
LOAD DATA INFILE '/home/vivedco/GroupsSchoolsFinal.csv' INTO TABLE GroupsSchools FIELDS TERMINATED BY ',';
When I submit that I get an error saying access is denied:
ERROR 1045: Access denied for user: 'vivedco_wick@localhost' (Using password: YES)
vivedco_wick was the password I used just yesterday to import the SQL file.
I'm wondering why I'm getting the access denied error?