diff options
Diffstat (limited to 'mariadb/mariadb-show-users')
-rwxr-xr-x | mariadb/mariadb-show-users | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mariadb/mariadb-show-users b/mariadb/mariadb-show-users new file mode 100755 index 0000000..1cbd074 --- /dev/null +++ b/mariadb/mariadb-show-users | |||
@@ -0,0 +1,13 @@ | |||
1 | #!/bin/bash | ||
2 | mariadb <<. | ||
3 | select | ||
4 | concat (host, '@', user) | ||
5 | as | ||
6 | user | ||
7 | , json_detailed (priv) | ||
8 | as | ||
9 | priv | ||
10 | from | ||
11 | mysql.global_priv | ||
12 | \G | ||
13 | . | ||