Advertisement
Guest User

Untitled

a guest
Aug 27th, 2015
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. mygrants()
  2. {
  3. mysql -B -N $@ -e "SELECT DISTINCT CONCAT(
  4. 'SHOW GRANTS FOR \'', user, '\'@\'', host, '\';'
  5. ) AS query FROM mysql.user" | \
  6. mysql $@ | \
  7. sed 's/\(GRANT .*\)/\1;/;s/^\(Grants for .*\)/## \1 ##/;/##/{x;p;x;}'
  8. }
  9.  
  10. mygrants --host=localhost --user=root --password=secret
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement