MySQL Tipps und Tricks

From Lolly's Wiki
Revision as of 10:14, 29 December 2014 by Lollypop (talk | contribs) (Die Seite wurde neu angelegt: „Kategorie:MySQL ==Einzeiler== ===Alle Grants=== <source lang=bash> # mysql --skip-column-names --batch --execute 'select concat_ws("@",user,host) from my…“)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

Kategorie:MySQL


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 {}'
Retrieved from "https://lars.timmann.de/wiki/index.php?title=MySQL_Tipps_und_Tricks&oldid=644"