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 -pBasic 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;