WordPress.org

Forums

Acunetix WP Security
[Plugin: WP Security Scan] The table prefix change left me unable to get into the site. (2 posts)

  1. mhightower
    Member
    Posted 4 years ago #

    After backing up my database. I executed the change table prefix link. It executed without a problem and said successful. I refreshed and an error said that I didn't have permission to to view any pages as the admin user. None of the support suggestions helped.

  2. stvwlf
    Member
    Posted 4 years ago #

    try this article. make sure you have a backup of your database as it is now before making these changes.
    http://beconfused.com/2007/how-to-solve-you-do-not-have-sufficient-permissions-to-access-this-page-in-wordpress/

    An alternative is to restore the database backup you made before running the security scan. That would put you back where you were before you ran the security scan. If you restore you will have to change one line in the wp-config.php file related to database table prefix, back to what it was before the security scan changed it. (I assume it changed it - use PHP My Admin to see what the prefix on your database tables is now, and make sure wp-config.php has the same prefix on the line "$table_prefix =" If it doesn't, change it in wp-config.php to what it is in the database - that may solve your problem. If you don't know, wp-config.php is a file in the root folder of your WordPress installation).

    If you need to restore your webhost may help. Or you can do it yourself in PhpMyAdmin. You can find tutorials on Google.

    Just be certain you make another backup of the database the way it is now, and that you know which backup is which.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic