title: mysqldump access denied
body: <p>When I try to backup using mysqldump from ssh,
  I run the following command on machine 10.64.1.1. It gives the following error.</p>
  
  <p><code>mysqldump --user=test -p=password --host=10.64.1.2 --tab=. databasename tablename</code></p>
  
  <p><code>mysqldump: Got error: 1045: Access denied for user 'test'@'10.64.1.1' (using password: YES)</code> when trying to connect</p>
  
  <p>However, I can access mysql using the same user and password.</p>
  
  <p><code>mysql --user=test -p[password]</code></p>
  
  <p>Current user:       <code>test@10.64.1.1</code></p>
  
  <p>SSL:            <code>Not in use</code></p>
  
  <p>Current pager:      <code>stdout</code></p>
  
  <p>Using outfile:      <code>''</code></p>
  
  <p>Using delimiter:    <code>;</code></p>
  
  <p>Server version:     <code>5.0.91-50-log Percona SQL Server, Revision 73 (GPL)</code></p>
  
  <p>Protocol version:   <code>10</code></p>
  
  <p>Connection:     <code>10.64.1.2 via TCP/IP</code></p>
  
  <p>Updates:</p>
  
  <p>If I do following mysql document: <code>--password[=password]</code> or <code>-p[password]</code>. </p>
  
  <p>Since my password contains special symbol <code>@</code>, Mysql cannot detect user correctly. It complains:</p>
  
  <p><code>mysqldump: Got error: 1044: Access denied for user 'test'@'%' to database</code></p>