How do I list databases in MySQL?
To list database type the following command
Open Terminal
mysql {PRESS ENTER}
mysql> show databases;
This is the output of my command, it only listed the mysql default database, not quite what I wanted to see.
+--------------------+
| Database |
+--------------------+
| information_schema |
| test |
+--------------------+
The reason my databases weren’t listed is because I wasn’t logged in as root so when logging in I typed -u root and if you have a password you’ll have to do that by adding -p yourpassword
quit {PRESS ENTER}
mysql -u root {PRESS ENTER}
mysql> show databases; {PRESS ENTER}
+--------------------------+
| Database |
+--------------------------+
| information_schema |
| headliner |
| mysql |
| test |
+--------------------------+
Now I’m able to see all databases that I’ve installed.