title: Which are the proper privileges to mysqldump for the Error Access denied when executing 'SELECT INTO OUTFILE'.?
body: <p>backup user has BackupAdmin role and ALL privileges (object rights, DDL, GRANT).</p>
  
  <pre><code>cmd&gt; mysqldump --routines=TRUE --tab=C:\tmp -h localhost -u backup -pbackup schemalocal
  cmd&gt; mysqldump: Got error: 1045: Access denied for user 'backup'@'%' (using password: YES) when executing 'SELECT INTO OUTFILE'
  </code></pre>
  
  <p>The only way to make it work is to give DBA role to backup account, but that is a security risk so I want to give it only the neccesary rights.
  Which are them?</p>