mysql connect with password command line code example

Example 1: login to database mysql terminal

mysql -u USERNAME -p

Example 2: login to database mysql terminal

use DBNAME;