Sometimes you have lot of database on your MySQL server, this list of database could be so many, but you just need to work with one of these database. This article show step by step to select and start working with the database.

1. Login and connect to you MySQL database:

# mysql -u root -p

2. List all MySQL database available on the server:

  mysql> SHOW DATABASE;

3.. Choose the database that you want to work with:

  mysql> USE mysql-database-name;

This example show that we change and start working with the current database that named 'mysql-database-name';

Please change the 'mysql-database-name' with the database that you want to work with.