MySql Cli commands

 

MySQL command-line client Commands

Connect to MySQL server using mysql  command-line client with a username and password (MySQL will prompt for a password):

mysql -u [username] -p;
Code language: SQL (Structured Query Language) (sql)

Connect to MySQL Server with a specified database using a username and password:

mysql -u [username] -p [database];
Code language: SQL (Structured Query Language) (sql)

Exit mysql command-line client:

exit;
Code language: SQL (Structured Query Language) (sql)

Export data using mysqldump tool

mysqldump -u [username] -p [database] > data_backup.sql;
Code language: SQL (Structured Query Language) (sql)

To clear MySQL screen console window on Linux, you use the following command:

mysql> system clear;
Code language: SQL (Structured Query Language) (sql)