-- List down databases MariaDB [(none)]> show databases; +--------------------+ | Database.          | +--------------------+ | information_schema | | mysql              | | performance_schema | | test               | | testdb             | | testdb1            | +--------------------+ 6 rows in set (0.001 sec) -- Check the status: MariaDB [(none)]> status -- Drop database: MariaDB [(none)]> DROP DATABASE testdb; Query OK, 0 rows affected (0.022 sec)

1
2
3
4
5
6
7
8
9
10
11
12
13
14

C:\Program Files\MariaDB 10.4\bin>
mysql -u root -p
Enter password: ****
MariaDB [(none)]>
show databases like 'test%';
+--------------------+
| Database.          |
+--------------------+
| test               |
| testdb1            |
+--------------------+
5 rows in set (0.001 sec)
MariaDB [(none)]>
SELECT schema_name FROM information_schema.schemata;