Differences

This shows you the differences between two versions of the page.

--- mysql:export_users_with_grants [2016/07/04 00:16] – peter
+++ mysql:export_users_with_grants [2020/07/15 09:30] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 ====== MySQL - Export users with grants ======
-Run this query:
+Make it easy to have all the queries needed to determine the grants for every user.
-<code mysql>
-### mysql -uroot -p{PASS} -B -N -e "SELECT DISTINCT CONCAT('SHOW GRANTS FOR \'', user, '\'@\'', host, '\';') AS query FROM mysql.user" | mysql -uroot -p{PASS} | sed 's/\(GRANT .\)/\1;/;s/^\(Grants for .\)/## \1 ##/;/##/{x;p;x;}'
-</code>
 <code mysql>
@@ Line 31: / Line 26: @@
 </code>
+Then get the actual grants for that user.
 <code mysql>
@@ Line 43: / Line 39: @@
 rows in set (0.00 sec)
 </code>
+To combine all the above, run this query:
+<code mysql>
+### mysql -uroot -p{PASS} -B -N -e "SELECT DISTINCT CONCAT('SHOW GRANTS FOR \'', user, '\'@\'', host, '\';') AS query FROM mysql.user" | mysql -uroot -p{PASS} | sed 's/\(GRANT .\)/\1;/;s/^\(Grants for .\)/## \1 ##/;/##/{x;p;x;}'
+</code>