title: Wordpress importing database - CREATE command denied to user
body: <p>I am trying to upload a WordPress database from local to hosting site. First, I solved the issue by replacing <code>utf8mb4</code> with <code>utf8</code> as you can view the error at <a href="http://take.ms/MoWG1T" rel="nofollow noreferrer">this link</a>.</p>
  
  <p><strong>Now I am getting the following issue:</strong></p>
  
  <pre><code>Error
  SQL query:
  
  --
  -- Database: `blogpost`
  --
  -- --------------------------------------------------------
  --
  -- Table structure for table `wp_commentmeta`
  --
  CREATE TABLE  `wp_commentmeta` (
  
   `meta_id` BIGINT( 20 ) UNSIGNED NOT NULL ,
   `comment_id` BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT  '0',
   `meta_key` VARCHAR( 255 ) COLLATE utf8_unicode_ci DEFAULT NULL ,
   `meta_value` LONGTEXT COLLATE utf8_unicode_ci
  ) ENGINE = INNODB DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci;
  
  MySQL said: Documentation
  
  #1142 - CREATE command denied to user 'blogsit_admin'@'localhost' for table 'wp_commentmeta' 
  </code></pre>
  
  <p>How to solve this issue?</p>