title: Error when importing sql database from phpmyadmin
body: <p>So, I export an SQL database from another pc that hosts my website(sucessfully appearing the tab of the site that is responsible for the sql table).</p>
  
  <p>But on my pc, I cannot get it to work. So it got to be a configurations error, something to do with privileges, or the sql database file.</p>
  
  <p>When I import a Database from phpmyadmin for hosting my website I get this error.</p>
  
  <pre><code>CREATE DATABASE `information_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
  
  MySQL said: Documentation
  #1044 - Access denied for user 'root'@'localhost' to database 'information_schema' 
  </code></pre>
  
  <p>SO, I go and delete the line    </p>
  
  <pre><code> CREATE DATABASE `information_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
  </code></pre>
  
  <p>The DataBases however are being imported and they have the necessary data in them. But, I go on deleting all the imported Databases except information_schema, phpmyadmin and mysql who I cannot delete.</p>
  
  <p>I load my Database again without this line and this time a get this error :</p>
  
  <pre><code>Error
  
  SQL query:
  
  -- --------------------------------------------------------
  --
  -- Table structure for table `CHARACTER_SETS`
  --
  CREATE TEMPORARY TABLE `CHARACTER_SETS` (
  `CHARACTER_SET_NAME` varchar( 32 ) NOT NULL DEFAULT '',
  `DEFAULT_COLLATE_NAME` varchar( 32 ) NOT NULL DEFAULT '',
  `DESCRIPTION` varchar( 60 ) NOT NULL DEFAULT '',
  `MAXLEN` bigint( 3 ) NOT NULL DEFAULT '0'
  ) ENGINE = MEMORY DEFAULT CHARSET = utf8;
  
  MySQL said: Documentation
  #1044 - Access denied for user 'root'@'localhost' to database 'information_schema' 
  </code></pre>
  
  <p>THis sql Database is 2.9 MB so in order to import it, I zip it and import it as a compressed .zip file.</p>
  
  <p>This question is a followup from <a href="https://stackoverflow.com/questions/18979274/sql-query-empty-result-on-php-code">this</a> question, when I realized that my problem is not on the php code as it works on another pc by another person(with whom I do not have contact with).</p>
  
  <p>Thanks in advance. </p>
  
  <p>PS: I performed those as well. The problem remains.</p>
  
  <pre><code>mysql&gt; GRANT ALL PRIVILEGES ON * . * TO 'root'@'localhost';
  Query OK, 0 rows affected (0.00 sec)
  
  mysql&gt; FLUSH PRIVILEGES;
  Query OK, 0 rows affected (0.00 sec)
  </code></pre>