Create a MySQL Database

How to create a MySQL 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.

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;