PJR Sales and Service - Knowledgebase - I get an error 'ACCESS DENIED CREATE DATABASE db

Computer Co-op, CornerNET Internet Gateway, and PJR Solutions is owned by PJR Sales & Service. Quality products and online services since 1991. We can be your
Complete Computer Connection

Hosting @ $5.95

Domains @ $16.98

Home Page

Knowledgebase
You are here: Portal Home > Knowledgebase > cPanel Related Issues > MySQL management issues > I get an error 'ACCESS DENIED CREATE DATABASE db_name' when I try to import a database

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:
Open the MySQL dump with a text editor on your local PC / MAC;
Delete the line saying "CREATE DATABASE yourdbname". Usually this line is found at the very beginning of the file;
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.

Add to Favourites
Print this Article

Also Read

How can I import a large database to my account? PhpMyAdmin times out. (Views: 11278)

I get syntax error when trying to run a MySQL query. (Views: 1060)

I don't have enough privileges for creating/dropping databases in PhpMyAdmin (Views: 2706)

I have problems accessing my MySQL database remotely (Views: 5298)

My application cannot connect to my database. (Views: 5026)