Differences

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

--- mysql:privileges [2016/07/19 18:08] – peter
+++ mysql:privileges [2020/07/15 09:30] (current) – external edit 127.0.0.1
@@ Line 95: / Line 95: @@
 MySQL stores proxy privileges in the **mysql.proxies_priv** table.
+===== Display all user's grants =====
+<code mysql>
+mysql -Bse "SELECT CONCAT('SHOW GRANTS FOR \'', user ,'\'@\'', host, '\';') FROM mysql.user" | mysql -Bs | sed 's/$/;/g'
+</code>
@@ Line 112: / Line 118: @@
 <code mysql>
-REATE USER 'peter'@'localhost' IDENTIFIED BY 'mypass';
+CREATE USER 'peter'@'localhost' IDENTIFIED BY 'mypass';
 GRANT ALL ON db1.* TO 'peter'@'localhost';
 GRANT SELECT ON db2.invoice TO 'peter'@'localhost';