PDA

View Full Version : Importing Textfile: Access Denied error


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?