connect to mysql from command line code example

Example 1: mysql login console

mysql -u USERNAME -p

Example 2: mysql connect command

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

Example 3: mysql cli connect with password

mysql --user=root --password=mypass