cPanel users can use a wizard to create a database.
Log in to your cPanel -> MySQL Database Wizard.
Enter a database name and hit Next.
Next, enter your Username and Password and hit Create user.
Select ALL PRIVILEGES and hit Next Step.
How to use command line to create your DB
Terminal into your server
Type: mysql -u root -p
You will be prompted for your MySQL root password
Once you see the MySQL prompt, use the following lines to create your database and user.
CREATE DATABASE db_name;
GRANT ALL PRIVILEGES ON *.* TO ‘db_user’@’localhost’ IDENTIFIED BY ‘user_passwd’;
*To create select permissions use
GRANT SELECT ON *.* TO ‘db_user’@’localhost’;
\q to exit
