Selecting MySQL Database



To get a list of database installed on your MySQL, you need to type the following command:

mysql> show databases;

To select a database, type the following command:

mysql> use xyzdatabase

Alternately, you can select a database when connecting to mysql

%> mysql -u root -p xyzdatabase