MySQL - 3306

mysql

Interact with mysql databases

Capabilities

# Connect locally
mysql -u root -p'password'

# Connect remotely
mysql -u 'username' -p'password' -h $IP

Session Commands

# Check version
select version();

# Check current database user
select system_user();

# Select database to enumerate
show databases;
use example_db;

# Enumerate tables
show tables;
SELECT * FROM example_table;
SELECT example_val1, example_val2 FROM example_table WHERE example_val1 = 'username';

Last updated