title: How can I solve permissions error when importing MySQL databases with PHPMyAdmin?
body: <p>I'm developing a web site that is based around a MySQL db.
  Because I wanted to do it off-line first, I installed WAMP server on my machine. This has Apache, an SQL server, and PHP.</p>
  
  <p>I created a database on my off-line machine. The database is called<code>OffDB</code>, created by user <code>OffUser</code>, with password <code>OffPwd</code>. I have exported it to an SQL file (less than one MB).
  I want to import this db into my online db, which is called <code>OnDB</code>, created by user <code>OnUser</code>, with password <code>OnUser</code>. When I try to import in PHPMyAdmin, I get the following error:</p>
  
  <blockquote>
    <p>"User OnUser doesn't have permissions to access databse OffDB"</p>
  </blockquote>
  
  <p>In the off-line PHPMyAdmin, I added a new user, <code>OnUser</code>, with password <code>OnPwd</code>, and granted it all permissions to OffDB. Then I exported OffDB again, and atempted to import again. It failed with the same error. Same thing if I add new off-line user OnUser, with password OffPwd, and grant it permission - upon import I always get the error.
  How can I solve that? </p>