MariaDB [(none)]>
show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| testdb |
+--------------------+
5 rows in set (0.006 sec)
mysql>
SELECT * fROM information_schema.schemata;
+--------------+--------------------+----------------------------+------------------------+----------+--------------------+
| CATALOG_NAME | SCHEMA_NAME | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME | SQL_PATH | DEFAULT_ENCRYPTION |
+--------------+--------------------+----------------------------+------------------------+----------+--------------------+
| def          | mysql               | utf8mb4           | utf8mb4_0900_ai_ci | NULL | NO |
| def          | information_schema  | utf8             | utf8_general_ci | NULL | NO |
| def.         | performance_schema  | utf8mb4           | utf8mb4_0900_ai_ci | NULL | NO |
| def          | sys                 | utf8mb4     | utf8mb4_0900_ai_ci | NULL | NO |
| def          | testdb             | utf8mb4 | utf8mb4_0900_ai_ci | NULL | NO |
| def          | test               | utf8mb4 | utf8mb4_0900_ai_ci | NULL | NO |
+--------------+--------------------+----------------------------+------------------------+----------+--------------------+
6 rows in set (0.00 sec)
-- database list that match a pattern
mysql>
show databases like 'test%';
+------------------+
| Database (test%) |
+------------------+
| test |
| testdb |
+------------------+
2 rows in set (0.00 sec)