MySQL Tipps und Tricks

From Lolly's Wiki
Revision as of 10:15, 29 December 2014 by Lollypop (talk | contribs)
Jump to navigationJump to search

Tipps und Tricks


Einzeiler

Alle Grants

# mysql --skip-column-names --batch --execute 'select concat_ws("@",user,host) from mysql.user' | xargs -n 1 -i mysql --execute 'show grants for {}'