how to connect to a specific database in mysql code example

Example 1: login to database mysql terminal

mysql -u USERNAME -p

Example 2: mysql cli connect with password

mysql --user=root --password=mypass