WordPress: moving tables with changed prefix more activities should be done

I copied WordPress tables to another server and changed the prefix of the tables from wp_ to jwp_.
I got a problem, that none of my users can access WP Admin console.

Solution was found in Admin problems after moving wordpress comment.

you should do the following:

  • In my table, wp08_usermeta, I changed all occurrences of wp_capabilities, wp_user_level, and wp_autosave_draft_ids to wp08_capabilities, wp08_user_level and wp08_autosave_draft_ids
  • Then in table wp08_options I changed wp_user_roles to wp08_user_roles

That’s it. everything worked.