How do I select a MySQL database through CLI

Question

I ve managed to get into MySQL using the command line terminal  but when I tried to enter some SQL  it said  no database selected   how do I select a database  my database name is   photogallery  What code do I use to select it

User · Answer

Use the following steps to select the database:

mysql -u username -p

it will prompt for password, Please enter password. Now list all the databases

show databases;

select the database which you want to select using the command:

use databaseName;

select data from any table:

select * from tableName limit 10;

You can select your database using the command use photogallery; Thanks !

User · Answer

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  lt db host gt  -u  lt user gt  -D  lt db name gt  -p

User · Answer

Switch to a database    mysql  use  db name     MySQL Commands

User · Answer

USE database name   eg  if your database s name is gregs list  then it will be like this  gt  gt  USE gregs list

User · Answer

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

User · Answer

Alternatively  you can give the  full location  to the database in your queries a la   SELECT photo id FROM  my database name  photogallery    If using one more often than others  use USE   Even if you do  you can still use the database table syntax

User · Answer

Hope this helps   use  YOUR DB NAME

[mysql] How do I select a MySQL database through CLI?

Examples related to mysql