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

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.