#!/bin/bash
echo "===== A: validate ara_wp DB creds from wp-config"
mysql -uara_wp -p'WSyGEhao4AjxuzJuiZ' -h localhost -N -e "SELECT CURRENT_USER(), DATABASE(), VERSION();" 2>&1 | head -5
echo "===== B: ara_wordpress.db wp_users"
mysql -uroot -N -e "SELECT ID,user_login,user_email,LEFT(user_pass,40),user_registered FROM \`ara_wordpress.db\`.wp_users LIMIT 15;" 2>&1
echo "===== C: ara_commondb admins schema+rows"
mysql -uroot -N -e "DESC ara_commondb.admins;" 2>&1 | head -15
mysql -uroot -N -e "SELECT * FROM ara_commondb.admins LIMIT 10;" 2>&1 | head -15
echo "===== D: ara_commondb accounts sample"
mysql -uroot -N -e "DESC ara_commondb.accounts;" 2>&1 | head -10
echo "===== E: any WHMCS/whmcs config"
grep -rli "whmcs" /home/ara/public_html --include=*.php -l 2>/dev/null | head -5
echo "===== F: mysql grants for non-root users"
mysql -uroot -N -e "SELECT user,host,db FROM mysql.db;" 2>&1 | head -20