Knowledge Base

Get Expert Website Hosting

Choose website reliability and expertise with SiteGround!

Home / Database Support / MySQL Error Troubleshooting / 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

Last update: Aug 13, 2025

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.

Share this article