-
Show all MySQL Users’ GRANTS:
Bash |copy code |?1 2 # oIFS="$IFS"; export IFS=$'\n'; for i in $(mysql --skip-column-names --batch -e "SELECT user,host FROM mysql.user"); do USER=$(echo $i|awk '{printf $1}'); HOST=$(echo $i|awk '{printf $2}'); mysql --skip-column-names --batch -e "SHOW GRANTS FOR '$USER'@'$HOST'"; done; export IFS="$oIFS";
3
-
Recent Posts
Recent Comments
- Flashpaqdjs on Handy One-Liners
- Wirelessscm on Handy One-Liners
- Pwnall1337 on cPanel Exim and Perl’s Net::SMTP::TLS
Archives
Categories
Blogroll
2 Responses to Handy One-Liners