#!/bin/bash
echo "===== A: agv home listing"
ls -la /home/agv 2>&1 | head -50
echo "===== B: jbj home listing"
ls -la /home/jbj 2>&1 | head -50
echo "===== C: agv public_html"
ls /home/agv/public_html 2>&1 | head -40
echo "===== D: jbj public_html"
ls /home/jbj/public_html 2>&1 | head -40
echo "===== E: mysql.user authentication"
mysql -uroot -N -e "SELECT user,host,LEFT(authentication_string,80) FROM mysql.user WHERE authentication_string<>'';" 2>&1
echo "===== F: grants"
mysql -uroot -N -e "SELECT user,host,db,Select_priv,Insert_priv,Update_priv,Delete_priv,Super_priv,Grant_priv FROM mysql.db;" 2>&1 | head -40
echo "===== G: total DB size"
mysql -uroot -N -e "SELECT table_schema,COUNT(*),ROUND(SUM(data_length+index_length)/1048576,1) FROM information_schema.tables GROUP BY 1;" 2>&1