how to connect mysql on terminal code example

Example 1: login to database mysql terminal

mysql -u USERNAME -p

Example 2: login to database mysql terminal

use DBNAME;

Example 3: login to database mysql terminal

show databases;