Knowledge base

Find articles about information features, troubleshooting guides, and other technical information related to the hosting service Hostinger.

access_time
Wednesday, June 14, 2017
I get access denied errors when importing a database via phpMyAdmin
If access denied errors are displayed when you try to import MySQL backup file via phpMyAdmin, most likely your MySQL query contains invalid (forbidden) queries.

Please open your MySQL file and make sure there are no queries like 'use database' or similar. Also make sure your MySQL file does not contain any MySQL database names/usernames/passwords (if a file is being imported from another host, most likely database name or username/password will be different here).

Your MySQL file should contain standard queries like CREATE TABLE and INSERT in order to work properly.
backupdatabasemysqlaccess deniedphpmyadmindeniedaccesssupportedusesql