I get an error 'ACCESS DENIED CREATE DATABASE db_name' when I try to import a database

In order to solve this issue follow these steps:

  1. Open the MySQL dump with a text editor on your local PC / MAC;
  2. Delete the line saying "CREATE DATABASE yourdbname". Usually this line is found at the very beginning of the file;
  3. Save the file and try to import it again.

This problem is caused by the fact that your MySQL user does not have privileges to create new databases. Databases can be created only through cPanel's MySQL manager.

  • 23 Users Found This Useful
這篇文章有幫助嗎？

相關文章

What type of databases do you support? PGSQL and MySQL?

All our servers support MySQL and PostgreSQL databases. Also with any of our hosting packages...

How to repair a MySQL database?

In this article we will show you two ways to repair a MySQL database.  1) Through...

How to optimize a MySQL database using phpMyAdmin?

It is always a good idea to keep your databases' tables optimized. Fortunately, making this...

How to change the database engine of a MySQL database table?

In this article we will show you how to change the database engine of a MySQL table. Let's...

I have problems accessing my MySQL database remotely

If you have problems accessing your database at your web hosting account remotely please make...