Though most of the times, with your host you will be accessing server through cpanel or zpanel or plesk or any other control panel which makes access to MySQL database easier with phpMyadmin console. But, there are times when you may not have access to that. Here is the code snippet for creating MySQL database for wordpress without phpMyadmin interface. Login to your SQL shell, use below code snippet for how to create wordpress database manually.
/* Create Wordpress database */
CREATE SCHEMA db_name ;
GRANT ALL PRIVILEGES ON db_name.* to 'Username'@'localhost' IDENTIFIED BY 'Password';
Where below should be replaced by your desired names
db_name : Your preferred database name
Username : DB user name
Password : DB password