how connect to mysql database with it shell code example

Example 1: mysql login console

mysql -u USERNAME -p

Example 2: mysql cli connect with password

mysql --user=root --password=mypass