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.

cPanel is easy to work with when you have the right host to support you. If you need a reliable partner to help you manage your website with cPanel, check out our cPanel hosting services!

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to export/import a MySQL database via SSH

In this article we will show you how to export and import a MySQL database via SSH. Managing your...

Error about legacy type authentication (old-style) when connecting remotely to MySQL

This particular error can occur in some MySQL clients. The reason for it is that our servers...

How to change the password of a Mysql user in cPanel?

If you have already created a MySQL user through the cPanel -> Mysql Databases tool you may...

How to reset the password for a MySQL database?

You may need to change the password of your database in order to improve the security of your...

I cannot create views in MySQL

Regular MySQL users do not have privileges to create views in MySQL. If you try to execute CREATE...