WordPress.org

1. chrisbrousseau
   Member
   Posted 1 year 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 1 year 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 1 year 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 1 year 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.