mysql username and password command line code example

Example 1: mysql login console

mysql -u USERNAME -p

Example 2: mysql cli connect with password

mysql --user=root --password=mypass

Example 3: login to database mysql terminal

show databases;