I have been trying to load data from a file placed on the server using ftp, into a database I created, using MySql’s ‘Load data infile…’ query.
Each time I execute the query it errors out with the message -
“Access denied for ‘user’@xxx.xxx.xxx (using password) error: 1045”
Thing is I am already logged in. When I execute a second query as a test, it works fine so the connection is up and running. I have tried it using MySQl’s admin tool and from the command line and get the same result. I can’t figure this one out!
Second question, once I get the query to run, what is the path to the file ?
I’m guessing it would be: 'mydomain.com/folder/file …?
Thank your for your help.