How Can I See List All Users In A MySQL Database Server
Table of Content
- How Can I See List All Users In A MySQL Database?
Today we are going to write another Hacking Blog for Newcomers. In this blog, I will explain, How to see lists of all users and passwords in the MySQL database.
Log in MYSQL Database :-
You must log in to MYSQL Database as a root user using the following command.
mysql -u root -p
List all MYSQL Database :-
To see all MySQL database lists, execute the below command.
show databases;
After executing the above command, we got our database name called Joombla. Let’s grab information in the joombla database. For that, follow the below command.
use Joomble;
List all Joombla Table:-
Execute the following command to view all tables in the Joombla database.
show tables;
As you can see, we have 72 tables in the Joombla database, but we are interested in the eslfu_users table.
List all Important Creds in eslfu_users :-
According to the following image, we have got all columns in the eslfu_users table. For example, id, name, username, email, password.
List all Id & Username & Password Creds in eslfu_users :-
In the end, We get all users & passwords creds in username & password columns. But unluckily, the password is encrypted. To decrypt user passwords, you can use any online website.
select id,username,password,email from eslfu_users;
How Can I See List All Users In A MySQL Database Server
⭐⭐⭐⭐⭐
Rating: 5 out of 5.Recent Posts
- CVE-2022-30190 (Follina)-Microsoft Support Diagnostic Tool Vulnerability
- SQL INJECTION – Extracting Username and Password From Database
- How To Dump Username And Password Using SQLMap Tool?
- Protected: Exploit Apache Log4j Security Vulnerabilities – CVE-2021-44228
- Hack The Box Previse HTB CTF Machine Walkthrough
Most Popular Posts
Very Intrusting BLog post sir i found this blog in great blog
Hi…
The sites are truly obvious and one can believe the information and data gave in the composition.
Ethical Hacking Training to get some answers concerning cysecon