After Migration, account locked out and password reset broken

  • Resolved mbbyrd

    (@mbbyrd)


    7 years, 6 months ago

    I recently migrated my WordPress site from a paid hosting service to my ajenti server. I restored the backed up site to a fresh installation of wordpress on the server. The site is up and running fine. However, I can no longer log into the admin center, and my site’s password recovery isn’t sending a reset link to my email address. It says ’email sent’, but I never receive an email.

    I tried inserting a new user directly into the database. It will create a user, but when I try to modify the wp_usermeta table to add the proper permissions, it can’t find the table.

    Any ideas?

Viewing 3 replies - 1 through 3 (of 3 total)

  • I have been in your shoes, can be very frustrating.

    You can do this via SQL Query in PHPMyAdmin. Select your database and run the following query (with your username / new password entered)

    UPDATE 'wp_users' SET 'user_pass'= MD5('yourpassword') WHERE 'user_login'='yourusername';

    Put your new password in place of yourpassword and replace yourusername with your WordPress username.

    You can also check your DB wb_options table to see if the URL is correct for the new site.

    More information regarding password change: https://wpcrux.com/blog/change-wordpress-password-phpmyadmin/

    Thread Starter mbbyrd

    (@mbbyrd)

    Thanks Liam – this worked. Note the following:

    Ajenti Server MySQL query input doesn’t like single quotes around table names or column names. So, I had to use the following format:

    UPDATE wp_users SET user_pass= MD5(‘yourpassword’) WHERE user_login=’yourusername’;

    Glad it is working!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘After Migration, account locked out and password reset broken’ is closed to new replies.