logo

Black Friday
Sale

  •  99.9% Uptime
  •  Free Domain Name
  •  24/7 Live Support
  •  30-Days Money-Back Guarantee
Get Started

Up To

90

%

OFF

00
DAYS
02
HOURS
51
MINUTES
15
SECONDS
Black Friday Sale: Cheap Web Hosting
From RM2.99 /Month!
See All Deals
×

Knowledge base

Find information within our custom articles about Hostinger's features
and all information relating to hosting practices.

I get access denied errors when importing a database via phpMyAdmin

Modified on:
mysql database access denied phpmyadmin denied access supported use backup sql

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.