summaryrefslogtreecommitdiff
path: root/mariadb/mariadb-list-databases
diff options
context:
space:
mode:
Diffstat (limited to 'mariadb/mariadb-list-databases')
-rwxr-xr-xmariadb/mariadb-list-databases12
1 files changed, 12 insertions, 0 deletions
diff --git a/mariadb/mariadb-list-databases b/mariadb/mariadb-list-databases
new file mode 100755
index 0000000..527ec90
--- /dev/null
+++ b/mariadb/mariadb-list-databases
@@ -0,0 +1,12 @@
1#!/bin/bash
2mariadb -t "$@" <<.
3select
4 @@hostname
5, @@server_id
6, schema_name
7as
8 'database'
9from
10 information_schema.schemata
11;
12.