MySQL Command Line code example

Example 1: mysql login console

mysql -u USERNAME -p

Example 2: mysql execute command from command line

mysql -u <user> -p -e "select * from schema.table"

Example 3: mysql command

mysqladmin -u root -p shutdown
mysqld –uroot –p Or mysql.exe -uroot -p

Example 4: login to database mysql terminal

use DBNAME;

Example 5: login to database mysql terminal

show databases;