connect to mysql server on command line linux 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

Example 3: login to database mysql terminal

use DBNAME;

Example 4: login to database mysql terminal

show databases;