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.

  • 0 Користувачі, які знайшли це корисним
Ця відповідь Вам допомогла?

Схожі статті

Can I change the name of a MySQL database?

The name of a MySQL database consists of a prefix, which is your cPanel username, followed by a...

How can I change my MySQL database collation?

Usually you will be interested in changing your MySQL collation in order to solve problems with...

How can I empty a MySQL database?

The easiest way to empty a MySQL database is through phpMyAdmin.  Once in phpMyAdmin, select the...

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...

How to change the MySQL timezone

When you develop your website, you may have to compare a certain date/time with the current...