[Plugin: WP Security Scan] Table Prefix : extra step

not seeing this information here, i’d like to share

after altering the table prefix, you gotta run this SQL:

UPDATE MYNEWPREFIX_usermeta SET meta_key = REPLACE( meta_key , ‘wp_’, ‘MYNEWPREFIX_’ );

don’t remember where i found the solution… too much code these days… but i’ve been replacing various table prefixes without trouble

http://wordpress.org/extend/plugins/wp-security-scan/