The query below lists user databases (schemas) on MariaDB instance.
select schema_name as database_name from information_schema.schemata where schema_name not in('mysql','information_schema', 'performance_schema','sys') order by schema_name;
- database_name - database (schema) name
- One row: represents one database (schema)
- Scope of rows: all databases (schemas) on MariaDB instance excluding system ones
- Ordered by: database (schema) name
Below is the sample results generated by query