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;