get all databases mysql code example

Example 1: mysql list databases

SHOW DATABASES;

Example 2: mysql get db name

SELECT DATABASE();

Example 3: how to see database in mysql command line

mysql -u user -p