mysql shell connect to database code example

Example 1: mysql login console

mysql -u USERNAME -p

Example 2: connect to mysql localhost from the mysql shell

\connect root@localhost:3306

Example 3: login to database mysql terminal

use DBNAME;

Example 4: login to database mysql terminal

show databases;