Some useful commands and queries

commands.md

Socat to listen to UDP Traffic:

socat - UDP4-LISTEN:8125,reuseaddr,fork

Share an encrypted message:

echo -n "secret" | openssl enc -aes-256-cbc -a -k "password"
echo "encryptedOutput" | openssl enc -d -aes-256-cbc -a

MySQL find number of connections for each host:

select host, count(*) from (SELECT left(host,char_length(host)-6) as host FROM information_schema.processlist) as a group by host;