I have created a table in a database. I want to populate the table with data that is present in a flat file. phpMyAdmin allows me to create the table but strangely when I try to populate it, I get an error message. My SQL statement is:
LOAD DATA INFILE '/home/vikas/automation/ph1_data' INTO TABLE PH1 FIELDS TERMINATED BY ' '
And I get the message:
MySQL said: Access denied for user: 'vikas@localhost' (Using password: YES)
Now my password is not YES but Im getting this error.
Please help!!!
Vikas
LOAD DATA INFILE '/home/vikas/automation/ph1_data' INTO TABLE PH1 FIELDS TERMINATED BY ' '
And I get the message:
MySQL said: Access denied for user: 'vikas@localhost' (Using password: YES)
Now my password is not YES but Im getting this error.
Please help!!!
Vikas