WordPress Login Password From the CLI

WordPress Login Password from the CLI

Get the WordPress Login PassWord From the CLI Steps


WordPress Login Password from the CLI


If you forget the WordPress password/you want to change the password from the CLI.


WordPress Login PassWord From the CLI Steps


Step 1:


Login to SSH using root access.


Step 2:


Type the below command to open MySQL/MariaDB in the CLI.

  • mysql
 

WordPress Login Password From The CLI

 

Step 3:

 

  • Next, find the Database name and user for the domain you need to reset the password.
  • You can find those details under “wp-config.php”
 

WordPress Login Password from the CLI


  • Copy the Database name in the DB_NAME.
  • Now we can assume the DB_NAME as “test_DB”
 

Step 4:

 

  • Use the command “use name-of-database”
  • use test_DB
 

WordPress Login Password from the CLI


Step 5:

 

  • Use the below command to view the WordPress table.
  • Show tables LIKE ‘%users’;
  • Here you can view the WordPress table.
 

WordPress Login Password from the CLI


  • Now we can assume the table as “test_table”
 

Step 6:

 

  • Use the below command to view the username and password used in the login page.
  • SELECT ID, user_login, user_pass FROM name-of-table-you-found WHERE user_login = ‘username used in login page’;
  • Now we can assume the username as “admin”.
    • name-of-table-you-found = test_table
    • username used in login page = admin
  • Use the command as below.
    • SELECT ID, user_login, user_pass FROM test_table WHERE user_login = ‘admin’;
 

WordPress Login Password from the CLI


Step 7:

 

  • You can use the below command to update the new password for the username.
  • UPDATE name-of-table-you-found SET user_pass=MD5(‘new-password’) WHERE user_login = ‘username used in loginpage’;
    • name-of-table-you-found = test_table
    • username used in loginpage = admin
    • new-password = NewPassword@1234
  • From the CLI use a simple password such as “NewPassword@1234”
  • Once you change the password from the CLI and once you login to the WordPress successfully, set a strong password.
  • Use the command as below.
    • UPDATE test_table SET user_pass=MD5(‘new-password’) WHERE user_login = ‘admin’;
  • Now the password has been successfully updated and changed.
 

Step 8:

 

  • To confirm if the password has been changed or not.
  • Follow the “Step 6”
  • Copy the user_pass in a Notepad.
  • Check with the old user_pass already copied in the Notepad
  • If the values differs then the password has changed.
 

Step 9:


  • Enter the “exit” command (Exits the MySQL client)
 

Step 10:


Login to WordPress Login password from the CLI has been altered.


WordPress Login Password from the CLI

Share on facebook
Facebook
Share on twitter
Twitter
Share on pinterest
Pinterest
Share on linkedin
LinkedIn
More Interested Related Posts

DirectAdmin Server Management Plans

Premium Support

24/7 End User Support from your Helpdesk
$ 99 Monthly / Server
  • Unlimited Support Plan
  • 24/7 Emergency Phone
  • Chat Support for Admin
  • Separate Account Manager
  • NDA & SLA
  • SLA Review Meetings
  • FREE Consultancy Services
  • Simple SignUp Process
  • Instant Account Activation
  •  

Platinum Support

24/7 Proactive Support
$ 49 Monthly / Server
  • Unlimited Support Plan
  • 24/7 Emergency Phone
  • Chat Support for Admin
  • Separate Account Manager
  • Advance Proactive Monitoring
  • Guaranteed SLA
  • SLA Review Meetings
  • 3rd Party Application Support
  • FREE Consultancy Services
  • Server Migration Support
  • Weekly Status Report
  • No End User Support
Popular

Unlimited Support

24/7 Support

$ 30 Monthly / Server
  • Unlimited Support Plan
  • 24/7 Support
  • Basic Monitoring
  • 30 Minutes Response Time
  • 4 Hours Resolution time for the Possible Issues
  • Security and Performance Optimization
  • React to Customers queries
  • Simple SignUp Process
  • Instant Account Activation
  • No Third party application support
  • No Migration and End User Support

Cpanel Server Management Plans

Premium Support

24/7 End User Support from your Helpdesk

$ 99 Monthly / Server
  • 24/7 End User White Label Support
  • Unlimited Number of Tickets
  • Chat Support for Admin
  • Separate Account Manager
  • Guaranteed SLA
  • Weekly Status Reports
  • FREE Consultancy Services
  • Simple SignUp Process
  • Instant Account Activation

Platinum Support

24/7 Proactive Server Management
$ 49 Monthly / Server
  • Unlimited Support Plan
  • 24/7 Emergency Phone
  • Chat Support for Admin
  • Separate Account Manager
  • Advance Proactive Monitoring
  • Guaranteed SLA
  • SLA Review Meetings
  • 3rd Party Application Support
  • FREE Consultancy Services
  • Server Migration Support
  • Weekly Status Report
  • No End User Support
Popular

Unlimited Support

24/7 Server Management

$ 29 Monthly / Server
  • Unlimited Admin Tasks
  • 24/7 Support
  • Basic Monitoring
  • 30 Minutes Response time
  • 4 hours Response time for possible issues
  • Security and Performance Optimization
  • React to Customers queries
  • No Third party application support
  • No Migration and End User Support

Cpanel Server Management Plans

Premium Support

24/7 End User Support from your Helpdesk

$ 99 Monthly / Server
  • 24/7 End User White Label Support
  • Unlimited Number of Tickets
  • Chat Support for Admin
  • Separate Account Manager
  • Guaranteed SLA
  • Weekly Status Reports
  • FREE Consultancy Services
  • Simple SignUp Process
  • Instant Account Activation

Platinum Support

24/7 Proactive Server Management
$ 49 Monthly / Server
  • Unlimited Support Plan
  • 24/7 Emergency Phone
  • Chat Support for Admin
  • Separate Account Manager
  • Advance Proactive Monitoring
  • Guaranteed SLA
  • SLA Review Meetings
  • 3rd Party Application Support
  • FREE Consultancy Services
  • Server Migration Support
  • Weekly Status Report
  • No End User Support
Popular

Unlimited Support

24/7 Server Management

$ 29 Monthly / Server
  • Unlimited Admin Tasks
  • 24/7 Support
  • Basic Monitoring
  • 30 Minutes Response time
  • 4 hours Response time for possible issues
  • Security and Performance Optimization
  • React to Customers queries
  • No Third party application support
  • No Migration and End User Support