Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mygrants()
- {
- mysql -B -N $@ -e "SELECT DISTINCT CONCAT(
- 'SHOW GRANTS FOR \'', user, '\'@\'', host, '\';'
- ) AS query FROM mysql.user" | \
- mysql $@ | \
- sed 's/\(GRANT .*\)/\1;/;s/^\(Grants for .*\)/## \1 ##/;/##/{x;p;x;}'
- }
- mygrants --host=localhost --user=root --password=secret
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement