How to use the MySQL Wizard in cPanel
cPanel users can use a wizard to create a database.
Log into 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
