I have tried to import a MySQL database, but got an “access denied” error.

The most likely cause for this is that the MySQL file you are trying to import contains a “CREATE DATABASE” line.

The permission to create databases is not granted to ordinary users – and is not necessary, as your database is already created for you.

To fix the problem, simply edit the MySQL file your are trying to import and remove the lines beginning with the words “CREATE DATABASE” and “USE” and then you should be able to import successfully.

Posted in: Questions about MySQL databases