If you get this error, you do not have privileges on user_* to use Create. HostGator needs to correct this issue for you.
If you open your database which you plan to import to your HostGator web hosting, you can find the following MySQL commands:
CREATE DATABASE IF NOT EXISTS `006` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `006`;
Here are 2 methods to solve this issue.
First one: you can open your MySQL database, and remove “CREATE DATABASE IF NOT EXISTS `006` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;”. Reload, done!
Second method: edit export.php, which is under your phpMyadmin folder, find:
if (! $export_plugin->exportDBCreate($db)) {
break;
}
and comment or remove them to skip the creation of the create database statements:
/*
if (! $export_plugin->exportDBCreate($db)) {
break;
}
*/