Differences

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

--- mysql:privileges [2016/07/19 17:01] – 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>
+===== Possible permissions for a backup user =====
+<code mysql>
+mysql> GRANT FILE, SELECT, SHOW VIEW, LOCK TABLES, RELOAD, REPLICATION CLIENT ON
+*.* TO 'backup_user'@'localhost' IDENTIFIED BY 'some_password';
+Query OK, 0 rows affected (0.01 sec)
+mysql> flush privileges;
+Query OK, 0 rows affected (0.00 sec)
+</code>
 ===== Other examples =====
@@ Line 100: / 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';