mysql command code example

Example 1: mysql list databases

SHOW DATABASES;

Example 2: mysql login console

mysql -u USERNAME -p

Example 3: quit mysql

To exit from mysql type quit at the mysql> command-prompt

Example 4: mysql command

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

Example 5: login to database mysql terminal

use DBNAME;