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