In this article I have explained how you can import your WordPress SQL database backup file even when you do not have the 'create new database' privilege in phpMyAdmin. This is particularly useful when you are trying to import the SQL database as part of transferring your site from one host (old-host.com) to another host (new-host.com) and your new host doesn't have the 'Create new database' privilege in phpMyAdmin. In your phpMyAdmin page check for the 'create new database' privilege. If the privilege settings looks like the example shown below then your database import following the normal method is going to fail as it will try to create a database and you don't have permission to do that. [caption id="attachment_417" align="alignnone" width="192" caption="No privilege to create new database "][/caption] You will get the following error when trying to import the database file: #1044 - Access denied for user 'username'@'localhost' to database 'database_name' To get around this problem and to complete importing your database to your new host do the following: Login to your cPanel and click on 'MySQL Databases'. Create a new database with your preferred name (I am going to use the name 'newDB' for easy reference. You should have privilege to create a new database ...