Migrating wordpress to new host with new wp account

You have to insert a new row in the wp_users/wp_usersmeta table in the database. If you have access to phpMyAdmin(or any other application to handle MySQL) follow these steps:

Select the wp_users table, and click the Insert-tab

1. user_login – this is the username you want to use
2. user_pass – this is the password you want to use (be sure to select MD5 from the Function menu)
3. user_nicename – put whatever you would like to refer to yourself as (not your username)
4. user_email – this is the email account associated with this user
5. user_url – the url to your website
6. user_registered – when was this user registered – just select a date with the date selector
7. user_activation_key – you can leave this blank
8. user_status – leave this set to 0
9. display_name – same as user_nicename

Click Go/Save/Run ??

If everything is OK, continue to the wp_usermeta table. Here you would need to insert two rows, first:

1. umeta_id – leave this blank(it is automatically generated)
2. user_id – this is the id of the user you created in the previous steps
3. meta_key – for this step insert wp_capabilities
4. meta_value – insert exactly this – a:1:{s:13:”administrator”;b:1;}

Second insert:

1. umeta_id – leave this blank
2. user_id – this is the id of the user you created
3. meta_key – for this step insert wp_user_level
4. meta_value – insert 10

Hope this helps ??

When I went into the wp_users table I saw the other developers old information in there and used that username and password to login but it didn’t work. I changed the password and selected MD5 from the menu for the password per these codex instructions and that didn’t work.

I then decided to leave that user alone when it didn’t work and create a new second user following your instructions. I followed every step precisely and then tried to login with that new user info and it didn’t work.

I appreciate your help! I am stumped. Here is a list below of the rows in wp_usermeta for the old developer’s admin user. Not sure if this is the problem and if I should delete his admin user all together?

1;”1″;”first_name”;
2;”1″;”last_name”;
3;”1″;”nickname”;”admin”
4;”1″;”description”;
5;”1″;”rich_editing”;”true”
6;”1″;”comment_shortcuts”;”false”
7;”1″;”admin_color”;”fresh”
8;”1″;”use_ssl”;”0″
9;”1″;”show_admin_bar_front”;”true”
10;”1″;”wp_capabilities”;”a:1:{s:13:””administrator””;b:1;}”
11;”1″;”wp_user_level”;”10″
12;”1″;”dismissed_wp_pointers”;”wp350_media
13;”1″;”show_welcome_panel”;”1″
14;”1″;”wp_dashboard_quick_press_last_post_id”;”2791″
15;”1″;”wp_user-settings”;”libraryContent=browse&editor=tinymce”
16;”1″;”wp_user-settings-time”;”1405537495″
17;”1″;”edit_page_per_page”;”200″
18;”1″;”_woocommerce_persistent_cart”;”a:1:{s:4:””cart””;a:1:{s:32:””358aee4cc897452c00244351e4d91f69″”;a:8:{s:10:””product_id””;i:2659;s:12:””variation_id””;s:0:””””;s:9:””variation””;s:0:””””;s:8:””quantity””;i:5;s:10:””line_total””;d:99.75;s:8:””line_tax””;i:0;s:13:””line_subtotal””;d:99.75;s:17:””line_subtotal_tax””;i:0;}}}”
19;”1″;”nav_menu_recently_edited”;”54″
20;”1″;”managenav-menuscolumnshidden”;”a:4:{i:0;s:11:””link-target””;i:1;s:11:””css-classes””;i:2;s:3:””xfn””;i:3;s:11:””description””;}”
21;”1″;”metaboxhidden_nav-menus”;”a:11:{i:0;s:8:””add-post””;i:1;s:11:””add-product””;i:2;s:15:””add-home_slider””;i:3;s:13:””add-portfolio””;i:4;s:12:””add-post_tag””;i:5;s:15:””add-post_format””;i:6;s:20:””add-slider-locations””;i:7;s:16:””add-project-type””;i:8;s:22:””add-project-attributes””;i:9;s:15:””add-product_cat””;i:10;s:15:””add-product_tag””;}”

Ok, thats strange:) Seems like something is corrupted. You can try troubleshooting with one of the following:

1. Upload a new wp-login.php file (Make sure you get the wp-login.php-file from the correct version.
2. Log in from wp-login.php (https://www.yourdomain.com/wp-login.php)
3. Disable plugins (Rename the Plugins folder to something else, like pluginsX)
4. Try resetting your password with the reset password link

There is also some more tricks here: https://codex.www.ads-software.com/Login_Trouble

Really bizarre, I tried all of the above and none worked. Prior to disabling the plugins I tried resetting the password through the link and instead of the box popping up for me to type my email in, it redirected me to https://rrelief.com/?page_id=8&lost-password. Once I deleted the plugins the reset password link acted as normal and said password reset would be emailed to me but I never got an email. I then went back to the https://rrelief.com/?page_id=8&lost-password page and saw this on the page: [woocommerce_my_account]. Not sure if woo commerce is the culprit here? I deleted all plugins and uploaded a new wp-login.php file, and cleared my cookies/cache and can’t login to wp so I’m not sure what else to do.

My site is functioning fine I just can’t login to WP to edit it. Luckily I have DB and FTP access. I have no idea what the old developer did that is causing so many problems.