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