title: Clone MySQL database when had read-only permission
body: <p>I have <code>database1</code> (~500MB), which can be access in a read-only mode by <code>user1</code>.<br>
  I have empty database <code>database2</code>, with full privilege by <code>user2</code>.</p>
  
  <p>Now, I want to clone <code>database1</code> into <code>database2</code>.</p>
  
  <p>I have tried <code>mysqldump</code>, but it says <code>access denied</code>.</p>
  
  <p>Any better way? Thanks.</p>