MySQL
Port: TCP/3306
sudo nmap 10.129.14.128 -sV -sC -p3306 --script mysql*
mysql -u <user> -p<password> -h <IP address>
Connect to the MySQL server. There should not be a space between the '-p' flag, and the password.
show databases;
Show all databases.
use <database>;
Select one of the existing databases.
show tables;
Show all available tables in the selected database.
show columns from <table>;
Show all columns in the selected database.
select * from <table>;
Show everything in the desired table.
select * from <table> where <column> = "<string>";
Search for needed string
in the desired table.
select version();
Version
use mysql;
show tables;
select host, unique_users from host_summary;
Last updated