Server Context

-- Version & basic server info
SELECT VERSION();
SHOW VARIABLES LIKE 'hostname';
SHOW VARIABLES LIKE 'version_compile_os';

-- Show database list
SHOW DATABASES;

SELECT schema_name
FROM information_schema.schemata;

-- Switch DB (example)
USE <dbname>;

-- List tables in selected DB
SHOW TABLES;

SELECT table_name
FROM information_schema.tables
WHERE table_schema = 'target_database';

-- Inspect table structure
DESCRIBE <table>;
-- or
SHOW COLUMNS FROM <table>;

SELECT column_name, data_type
FROM information_schema.columns
WHERE table_schema = 'target_database'
AND table_name = 'target_table';


-- dump data
SELECT username, password
FROM inlanefreight.users;

-- Check filesystem access capability
SHOW VARIABLES LIKE 'secure_file_priv';

-- Check client-side file uploads (important for exploitation)
SHOW VARIABLES LIKE 'local_infile';