Handy One-Liners

 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