Knowledge Base Article

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


______________

Find expert web hosting services at SiteGround.com: secure web servers, cPanel, Fantastico, PHP, MySQL, FTP, web hosting tutorials, and more.


Rating

Please indicate if this article was helpful for you.
rating :  1.9 from 5
views :  794
votes :  8

Related Articles

Views

Valid XHTML 1.0 Strict Valid CSS!