MySql Tutorial: CREATE database, table & INSERT VALUE How to create database and tables in MySql using the terminal on UBUNTU ... mysql -r root -p enter you password SHOW DATABASES; CREATE DATABASE name; USE database_name; CREATE TABLE name (fields and their data types); DESCRIBE table_name; INSERT INTO table_name VALUE(field values); SELECT * FROM table_name: