Most web hostings have GUI for database management by when we don’t have GUI it is necessary to know how to create database and user in MySQL from terminal. Here is a simple example of how to do it in MySQL.