how to create a new connection in mysql from command line code example

Example 1: login to database mysql terminal

mysql -u USERNAME -p

show databases;