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.

  • 99 Users Found This Useful
Was this answer helpful?

Related Articles

#1064 - You have an error in your SQL syntax

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

Help, I deleted the files.

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

I can’t enter the site, it doesn’t work. What to do?

Sometimes your site may become unavailable and it may not be displayed for you. Here are the...

How can I turn off PHP error output?

To disable error output in your script, use: error_reporting (0); Remember that you need to...

Where can I see the CPU logs of the processor?

Our hosting does not keep logs of CPU usage of the processor at the moment.When an account starts...