Table of Contents
root@grand [~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 932677 Server version: 5.5.42-cll MySQL Community Server (GPL) Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
You can check the database name from the WordPress configuration file.
mysql> use user_images; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed ~
We need to select only the following details from “wp_users” table.
mysql> SELECT ID, user_login, user_pass FROM wp_users; +----+------------+------------------------------------+ | ID | user_login | user_pass | +----+------------+------------------------------------+ | 1 | admin | $P$BjUKUieEYT1B3TnkQHsv4Y8hfnSK5t. | +----+------------+------------------------------------+ 1 row in set (0.00 sec) mysql>
This WordPress has only one user “Admin”. The password displayed here isn’t real, it’s in MD5 encrypted format.
This is the point that we are looking for. As I mentioned, the password displayed is in MD5 format. In latest MySQL versions we can generate the password in MD5 format from the commandline itself. Please see the syntax:
mysql> UPDATE wp_users SET user_pass = MD5(‘WPEXPLORER’) WHERE ID=1 LIMIT 1;
In previous versions we have to enter the password in MD5 format.
Syntax to change the password
mysql> UPDATE wp_users SET user_pass = "61250b88abfe298f2df4821d081a3add" WHERE ID=1;
Here the user pass in MD5 format.
See the updated password:
mysql> SELECT ID, user_login, user_pass FROM wp_users; +----+------------+----------------------------------+ | ID | user_login | user_pass | +----+------------+----------------------------------+ | 1 | admin | 61250b88abfe298f2df4821d081a3add | +----+------------+----------------------------------+ 1 row in set (0.00 sec) mysql>
That’s it!! Now try to login with the new password.
In today's digital landscape, timing is everything. Whether you're a social media manager, business owner, or content creator, the success…
Are you a website owner? Maintaining the website is the prime concern for any website owner. Yes, it’s equally important…
If you’ve planned to launch a WordPress website, you might get a question, “How do I log in to WordPress?”…
As the demand for virtual private servers (VPS) continues to grow, businesses and individuals are faced with a crucial decision:…
Web hosting is a large industry, as many other factors help any web hosting provider to form a company. The…