title: mysqlimport: Error: 1045, Access denied
body: <p>Does anyone know why I get this error when running mysqlimport?</p>
  
  <pre><code>mysqlimport -u someone -pwhatever --columns=a,b,c,d,e bar /var/tmp/baz.sql
  mysqlimport: Error: 1045, Access denied for user 'someone'@'%' (using password: YES), when using table: baz
  </code></pre>
  
  <p>However...</p>
  
  <pre><code>mysql -u someone -pwhatever
  Welcome to the MySQL monitor.  Commands end with ; or \g.
  Your MySQL connection id is 199
  Server version: 5.1.41-3ubuntu12.10 (Ubuntu)
  
  Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  
  mysql&gt; show grants;
  +------------------------------------------------------------------------------------------------------------+
  | Grants for someone@%                                                                                   |
  +------------------------------------------------------------------------------------------------------------+
  | GRANT USAGE ON *.* TO 'someone'@'%' IDENTIFIED BY PASSWORD '*BLAHBLAHBLAH' |
  | GRANT ALL PRIVILEGES ON `bar`.* TO 'someone'@'%'                                          |
  +------------------------------------------------------------------------------------------------------------+
  2 rows in set (0.00 sec)
  
  mysql&gt;
  </code></pre>