title: Why do I get an error when using LOAD DATA INFILE?
body: <p>I'm trying to use <code>SQL</code> to upload a <code>csv</code> file from my laptop to a database, however I get a strange error. The code I am typing into the SQL window in phpMyAdmin is as follows:</p>
  
  <pre><code>LOAD DATA INFILE '/Users/myMac/testServerUpload.csv' 
  INTO TABLE `testDatabase` 
  FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'
  </code></pre>
  
  <p>But I get the following error:</p>
  
  <pre><code>Error
  
  SQL query:
  
  LOAD DATA INFILE '/Users/myMac/testServerUpload.csv' INTO TABLE `testDatabase` FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'
  
  MySQL said: Documentation
  #1045 - Access denied for user 'ukld'@'%' (using password: YES) 
  </code></pre>
  
  <p>Should I be using <code>LOAD DATA LOCAL INFILE</code> instead of my current command as the file is on my computer? Both give me an error, and I thought <code>LOCAL</code> might mean that it is on the server. I could not find relevant advice searching for this error.</p>