WordPress - Cannot login after migrating with All-in-one WP Migration
I have just used All-in-one WP Migration plugin to transfer my website onto another server with new domain. The problem is after the migration no accounts seem to work when logging in on
/wp-admin
or
/wp-login
. Neither the default account the fresh WP installation had, nor the accounts that were migrated with the site.
The problem is i cannot access database tonight, is there any way to make that work? Maybe plugin sets new admin account, anybody knows?
Solutions
If you know the databasename and password of the
wordpress install
you can insert a new user with mysql.
INSERT INTO `databasename`.`wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES ('4', 'demo', MD5('demo'), 'Your Name', '[email protected]', 'http://www.test.com/', '2011-06-07 00:00:00', '', '0', 'Your Name');
INSERT INTO `databasename`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '4', 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}');
INSERT INTO `databasename`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '4', 'wp_user_level', '10');
http://www.wpbeginner.com/wp-tutorials/how-to-add-an-admin-user-to-the-wordpress-database-via-mysql/
Similar questions
Cannot access wp-admin after migration to another place
I've been working in my blog. Yesterday I made all back-ups (files and DB), i´ve changed the wp-config.php with the new user, DB name and password and I publised everything at my actual URL. http://agenciamoka.com My test URL is http://mokaweb.com.br/Moka/ Well, everything was good until I decided to access wp-admin. When I tryied to access wordpre...
Migrating all of Wordpress website into one
Currently, i have 3 WooCommerce Wordpress websites. However, i want to migrating them into new one (Users, Pages, Posts, Products,...). I have tried to export and import individually each of section above. There is one problem : The Pages, Posts, Products are not associated with the correct Users Id anymore. The users Id is changed in the database ...
Wordpress redirects to old login after migration
I've followed all the steps for migrating my existing wordpress site to another server. However, when I try to login to the migrated site, it keeps redirecting me to the old one, despite whether I use wp-admin.php or wp-login.php. I have also read about a dozen different pages on migrating worpress accounts, but not one of them encounters the probl...
Updating Wordpress Password after migration causes login error
This is weird, probably a lack of knowledge about hashing but there is an issue I've seen in a couple of wordpress projects: After migrating a wordpress site from localhost to a commercial hosting any update of migrated users' password made in the new server will make the site (in the new server of course) not to recognize the new password.This hap...
Also ask