> For the complete documentation index, see [llms.txt](https://positifmobile.gitbook.io/flyweb/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://positifmobile.gitbook.io/flyweb/installation-admin-panel/create-database.md).

# 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.

![](https://3319500722-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-McTnNLRtNdragDlAvxs%2F-MfRq5g3zh67GVrQXgms%2F-MfSkG-SXRo_RM_IysZC%2Flogin-to-cpanel.png?alt=media\&token=0514a4c0-25e1-4ef5-946a-f9cc607b06fa)

Input your cPanel **`username`** , **`password`** and Login.

After login, look for an icon **`MySQL Database Wizard`**.

![](https://3319500722-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-McTnNLRtNdragDlAvxs%2F-MfRq5g3zh67GVrQXgms%2F-MfSkRqM6RI8m30-D6z9%2Fmysql-database-wizard.png?alt=media\&token=d20ce21e-6428-4255-a73b-07db6305484c)

### 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.

![](https://3319500722-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-McTnNLRtNdragDlAvxs%2F-MfRq5g3zh67GVrQXgms%2F-MfSkj5_dMDp2LccYUat%2Fcreate-database.png?alt=media\&token=660688f3-affc-4593-a918-45895760c88a)

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.

![](https://3319500722-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-McTnNLRtNdragDlAvxs%2F-MfRq5g3zh67GVrQXgms%2F-MfSl6__QXHSU15vWyG1%2Fcreate-database-user.png?alt=media\&token=6f6cf280-0d00-4b25-94b6-f2e3f31f09ef)

{% hint style="info" %}
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.
{% endhint %}

### 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.**

![](https://3319500722-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-McTnNLRtNdragDlAvxs%2F-MfRq5g3zh67GVrQXgms%2F-MfSlGKwIiXYec8WO4xn%2Fdatabase-privileges.png?alt=media\&token=6e28185d-87fa-483e-9438-f3519e1d4954)

{% hint style="info" %}
To grant all of the available privileges to the user, select the ALL PRIVILEGES checkbox.
{% endhint %}

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`**.