Wordpress admin password recovery

August 27, 2019 339 views

How can I recover the Wordpress admin password?
Upon creation of the 1 click Wordpress. Then somehow lost the password.
I cannot login in the web wp-admin and get the dashboard.

2 Answers

Hello,

You can easily recover your WordPress password by accessing the admin area login page and click the “Lost your password?” link. You can then enter either your Username or Email Address to receive the new password.

The other option is the reset the password from the wordpress database directly. If the above option is not working for you, I’ll explain how this one works.

Let me know how it goes.

Alex

  • Hello,
    Thanks for the reply. It didn’t work the link “lost my password”. Can you explain the other option?
    Thanks

    • Sure thing, may I ask if you have phpMyAdmin installed?

      Alex

      • Now, phpmyadmin installed. But how do I login

        • How did you installed phpMyAdmin on your server? You should be able to access it using your server IP address in your browser. However you can check your nginx/apache vurtual hosts to see if there is entry for phpmyadmin as well.

          You can reset the password from phpMyAdmin using the following steps:

          1. Access phpMyAdmin in your browser
          2. Click on the name of your WordPress database.
          3. Next click on the wpusers table. (your database might have different prefix, e.g jpipousers, but you still need to access the _users table)
          4. Click on Edit beside your WordPress admin user.
          5. In the user_pass field, paste your password by pressing Ctrl – V and from the drop-down, select MD5. Finally click on Go. You should now see a success message from phpMyAdmin saying the database record was updated.

          You can do this manually via the command line:

          1. Access mysql as root: mysql -u root
          2. List your databases: show databases;
          3. Select your database: use yourdatabasename;
          4. List the database tables: show tables;
          5. Update the password using this query: UPDATE `wp_users` SET `user_pass`= MD5('yourpassword') WHERE `user_login`='yourusername'; Keep in mind that if you have different prefix for the database you will need to change wp_users to match your database prefix.

          Once this is done you should be able to access your database.

          Let me know how it goes.

          Alex

          • I can load the phpmyadmin login page, however, I cannot login.
            Neither root nor any other available user. All getting an error.
            1698 - Access denied for user ‘root’@'localhost’
            or
            or the admin and the password set during installation.

            1045 - Access denied for user 'admin’@'localhost’ (using password: YES)

Hello,

Try to access mysql using the following command:

mysql -u root -p

Let me know how it goes

Alex

Have another answer? Share your knowledge.