mysql get schema create from command line code example

Example: create database terminal mysql

CREATE DATABASE dbname;