Error while importing a database

Website Building
#1

Hi, I am getting the following error message when importing the database. I would appreciate if someone can help me on this.

Thanks

Raj

Error
SQL query:

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 utf8mb4_unicode_ci DEFAULT NULL,
meta_value longtext COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
MySQL said: Documentation

#1044 - Access denied for user ‘id1489799_admin’@’%’ to database ‘information_schema’

#2

@rajbatra52 delete the database and create it again but this use different username(instead of admin).

Try the above…see if it works

#3

When you launch phpmyadmin/manage database MAKE SURE TO CLICK ON YOUR DATABASE NAME ON THE LEFT HAND SIDE.

Don’t click on information database.

#4

I was able to migrate the database. But it did not seem to work.
Basically I am trying to migrate my local wordpress website. I do not know
how to do it.

Regards

Raj