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.
Customer support has always been the backbone of the web hosting industry. From helping users set up domains to troubleshooting…
Content is the most vital asset for businesses navigating the digital era. But creating high-quality, engaging content consistently can be…
Welcome to the exciting world of Ollama, a revolutionary open-source tool that's democratizing access to Large Language Models (LLMs). If…
Managing files on your Amazon EC2 instances can often feel like navigating a complex maze, especially when you prefer a…
Welcome to the world of database management with MySQL Workbench! If you're new to databases or looking for a powerful,…