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

How do I turn off short open tags?

To disable short opening tags, you need to add the following code to your .htaccess file:...

Cron task not working when installing Drupal

To create a cron task, follow these steps: 1. You need to create a cron task in Control Panel -...

PHP Fatal error: Cannot redeclare

If you see PHP Fatal error: Cannot redeclare function it means that there is a problem in your...

I see HTTP code 200 when debugging a site

If you see a '200 OK' code while debugging your site, it means that your site is working fine....

How to fix content encoding error?

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