I am getting access error when importing database via phpMyAdmin

If an access error is displayed when you try to import a MySQL database backup via phpMyAdmin, it is likely that your MySQL database contains invalid (forbidden) queries.
Also, make sure that your MySQL file does not contain username / password / database name (if you imported the file from another hosting, most likely the database name / user / password will be different).
Your MySQL file should contain standard queries like CREATE TABLE and INSERT so that you don't have problems importing.

  • 85 Users Found This Useful
Was this answer helpful?

Related Articles

Help, I can not install the Joomla components!

This is a known Joomla issue where components cannot be installed through the browser window....

How to fix content encoding error?

If your site shows content encoding error it may be due to GZIP compression.Try to enable or...

Help, I deleted the files.

Backups are automatically created weekly on the Premium plan and daily on the Business plan. You...

Error 502 Bad Gateway nginx and why does it occur?

If this error occurs, then HTTP requests from clients to your site are going through some kind of...

#1064 - You have an error in your SQL syntax

Error 1064 occurs when MySQL version does not match. The simplest solution is to enable...