how to connect to mysql database from command line code example

Example 1: mysql connect command

mysql --host=localhost --user=myname --password mydb
mysql -h localhost -u myname -p mydb

Example 2: connect mysql command line

mysql --host=localhost --port=myport --user=myname --password
mysql -h localhost -u myname -p --port=myport

Example 3: login to database mysql terminal

use DBNAME;