Wordpress导入数据库 - 拒绝用户的CREATE命令

Question

I am trying to upload a WordPress database from local to hosting site. First, I solved the issue by replacing utf8mb4 with utf8 as you can view the error at this link.

Now I am getting the following issue:

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' 

How to solve this issue?