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 backup with a text editor on your local computer.
- 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.
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!