MariaDB - How to show database command?

dba
mariadb

#1

I have run mariadb server. It is created by friend but I can log in using the user name and password:

mysql -u root -p'PASSWORD' 

I try the following SQL but not working

see database;

and

show database;

How can i show run show database on mariadb?


#2

The actual SQL command is as follows to list and show databases:

SHOW DATABASES;

I hope this helps.


#3

Just the “s” at the end :

show databases;

And after the “use” command:

use db_name;
use wikidb;

You can see tables by :

show tables;

Also in plural.