Cannot import database

Website Building
#1

I was trying to import a database to migrate my website. Why can’t I import my database using the user I created along with it? Whenever I try to import my SQL backup file it says access denied for the user. It has happened with a lot of people here before me so I want to know what is the reason? How can I fix this? Mine is a FREE Account. Limitations?

This is the error

CREATE TABLE jvom_commentmeta (
meta_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
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,
PRIMARY KEY (meta_id),
KEY comment_id (comment_id),
KEY meta_key (meta_key(191))
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
MySQL said: Documentation

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

#2

That’s easy, and simple, click on the database you wish to import from and not on the information_schema, because, by default, when you login, information_schema will be selected :slight_smile:

1 Like
#3

@rawshn Solution suggested by @ckhawand will solve your issue. Try that. :slight_smile:

1 Like