how to login to mysql using cmd and creating database code example

CREATE DATABASE dbname;