How do I select a MySQL database through CLI?
Solution 1:
Use USE. This will enable you to select the database.
USE photogallery;
12.8.4: USE Syntax
You can also specify the database you want when connecting:
$ mysql -u user -p photogallery
Solution 2:
Switch to a database.
mysql> use [db name];
MySQL Commands
Solution 3:
While invoking the mysql CLI, you can specify the database name through the -D option. From mysql --help:
-D, --database=name Database to use.
I use this command:
mysql -h <db_host> -u <user> -D <db_name> -p