MySQL databases can be created either through phpmyadmin or through the SSH command line
Lets see how to create a MySQL database with SSH command
(i) First log in to mysql with your user name (change if not root). You will be prompted for a password.
mysql -u root -p
(ii) create the database with a unique name
CREATE DATABASE new_database;
(iii) The user “root” (or whoever is logged in) has privileges to the database. To give another user, access, type the command
GRANT USAGE ON new_database.* to other_user@localhost IDENTIFIED BY 'otheruser_passwd';
(iv) If you want to give the other_user all the priviliges, type the command:
GRANT ALL ON new_database.* to other_user@localhost;
(v) Now the other user can log in and access the database with the command
mysql -u other_user -p'passwd' new_database