Support » Plugin: Acunetix WP Security » [Plugin: WP Security Scan] danger! table rename breaks admin page

  • 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.

Viewing 3 replies - 1 through 3 (of 3 total)
  • 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_' );

    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.

    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.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘[Plugin: WP Security Scan] danger! table rename breaks admin page’ is closed to new replies.