How to use the MySQL Database Wizard to create a database

 

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 password

Once you see the MySQL prompt, use the following lines to create your database and user.

CREATE DATABASE ; CREATE USER ‘‘@’localhost’ IDENTIFIED BY ‘‘; GRANT ALL PRIVILEGES ON .* TO ‘user’@’localhost’; FLUSH PRIVILEGES; Exit;