mysql shell connect code example

Example 1: mysql connect command

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

Example 2: login to database mysql terminal

mysql -u USERNAME -p

Example 3: connect to mysql localhost from the mysql shell

\connect root@localhost:3306

Example 4: login to database mysql terminal

use DBNAME;

Example 5: login to database mysql terminal

show databases;