Basic command

Download

Download from:
https://dev.mysql.com/downloads/mysql/

Connect to SQL

The MySQL is installed PORT 3306 in default.

Navigate to the machine and type the following command:


mysql -U <user_name> -p
mysql -U root -p

Basic command


# List out all current Database
SHOW DATABASES;
SHOW SCHEMAS;
 
# Goto database
USE DATABASE_NAME;
USE my_db;
 
# Show all tables in a database
SHOW TABLES;
SHOW FULL TABLES;