WordPress.org

Ready to get started?Download WordPress

Forums

Acunetix WP Security
[Plugin: WP Security Scan] danger! table rename breaks admin page (4 posts)

  1. chrisbrousseau
    Member
    Posted 3 years ago #

    beware! database table rename from wp_ to another prefix looks like it will work, but in fact, broke my site (and others - google away), by locking me out of my admin pages - so I could not post! This plugin is not current - if you must harden your site, do it manually...

    Here is an excellent site that worked for me: http://tdot-blog.com/wordpress/6-simple-steps-to-change-your-table-prefix-in-wordpress

    Failing that, if you must try this plugin - then be sure to have ssh access and myphpadmin running; do all your backups, they will be needed.

  2. nronksr
    Member
    Posted 3 years ago #

    The Security scanner isn't up to date. It misses changing 4 permissions in the _usermeta table.

    wp_capabilities
    wp_usersettings
    wp_usersettingstime
    wp_dashboard_quick_press_last_post_id

    If you run this SQL query and change prefix to whatever you renamed it, it will fix your permissions issues:

    UPDATE 'PREFIX_usermeta' SET 'meta_key' = REPLACE( 'meta_key' , 'wp_', 'PREFIX_' );
    
    Example:
    UPDATE 'ea_usermeta' SET 'meta_key' = REPLACE( 'meta_key' , 'wp_', 'ea_' );
  3. S.o.Thunder
    Member
    Posted 3 years ago #

    Thanks nronksr! Are these the same steps to follow on the latest version of wordpress? I am using 3.0.1.
    I renamed my tables and lost access to the admin panel and need to figure out how to regain access.

  4. nronksr
    Member
    Posted 3 years ago #

    It works up to 3.0.5 for sure. I haven't checked out the latest structure, but they don't make drastic changes in minor revision numbering. I'd guess it would work with 3.1.1 as well...

    I'm currently running 3.0.5 - haven't upgraded to 3.1.1 yet (which is presently the latest) so no guarantees. But the revision number you listed as 3.0.1 would def. work for the fix above.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic