harry

How we can connect the database through terminal or shell:--

1. Go to your terminal with your mysql user name and password
and type the commands:--
CONNECT DATABASE NAME or USE DATABASE NAME

OUTPUT: Now You will be connected the current database.

2. After this if you want to know the all database on that host
Then type SHOW DATABASE you will find out all database.

3. If you want the all table list then type the following command
SHOW TABLE
4. If you want the table structure information then type the following command
DESCRIBE TABLE NAME