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.

1 comment
  • How can I recover my username thru terminal/console (when I don’t remember my pw also, though I can recover the pw if I knew username).

    1. How can I get PhpMyAdmin page to open in browser. Currently my wp site works, but PhpMyAdmin doesn’t open in the browser.

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
4 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

Hi @jpippo,

With openlitespeed wordpress image, you can try method:

  1. resend the password, be aware that mail probably in the spam
  2. get mysql wordpress user password from cat ~/.db_password then you can follow above method to reset it
  3. Relaunch again since it won’t cause you more than 5 mins to do so.

Best,
Eric

How can I recover my wp admin username thru terminal console (I forgot both, but I can recover password once I know the username).

I am using terminal console because I’m not able to open PhpMyAdmin in my browser, though my WP site is working ok.
Can you guide for both of the cases?

Submit an Answer