Selecting a database after connecting to MySQL from the command line.
This is very simple to select a particular database from the MySQL prompt.
You can use SQL command use to select a particular database.
Here is an example to select the database called mythconverg
At the command line begin by connecting to MySQL.
[root@host]# mysql -u root -p
Enter password:******
In the above the user root has been specified and the password is added on request.
mysql> use mythconverg;
Database changed
mysql>
In the above at the MySQL prompt set the database to be used, in this case mythconverg.
