Create Database

We will be creating a MySQL a new database for example flyweb , new user and granting the user access to the newly created MySQL database.

The very first step is to log in to your cPanel.

Input your cPanel username , password and Login.

After login, look for an icon MySQL Database Wizard.

Create a Database

The wizard will help you create a database, user and grant the required privileges.

The very first step is to create a database.

You can name is something like the site or anything you prefer.

Add a MySQL user

Next step is to create a user, Again, you can name this anything you prefer and create a strong password (keep a note of the password as you’d need it to continue with your website install, the password will not be visible to you once you are done creating the user).

Hit Create user once done.

If your hosting provider has enabled database prefixing, a prefix based on your account username and underscore character ( _ ) will precede the New Database text box. The system automatically prepends this prefix to the database name.

Add a user to a database

On this step you will see the username and database name you just created, Click the checkbox (ALL PRIVILEGES) to grant the newly create database user all privileges to connect to the database.

Once done, Click Next Step.

To grant all of the available privileges to the user, select the ALL PRIVILEGES checkbox.

If you see a success (green) message like above, you can safely assume, all went well and using the newly create username/password/database to continue with your Flyweb Admin install.