> ## Documentation Index
> Fetch the complete documentation index at: https://support.webcentral.au/llms.txt
> Use this file to discover all available pages before exploring further.

# Create/upload your database in cPanel

If your website needs a database, you will need to create one in cPanel, upload your database file to it and then connect it to your website. When you create your database and user, please remember the database name, username, and password as this will be used when connecting the database to your website.

## Create a database and user

1. In the **cPanel** main menu click **MySQL Database Wizard**

![](https://onlinesuccess.com.au/images/c186c9fe7c9a0d6ef7a139d943320ed0.png)

2. Under **Step 1: Create A Database**, type in a database name and click **Next Step**
3. Under **Step 2: Create Database Users**, type in a username and password and click **Create User**
4. Under **Step 3: Add user to the database**, tick the privileges you want to give the user

* You can tick **ALL PRIVILEGES** to have full control over the database

5. Under **Step 4: Complete the Task**, click **Return Home**
6. You have now created a database and user

## Upload your database

1. If you already have a database and want to transfer it to your cPanel, download your database from your current website host onto your computer
2. In the **cPanel** main menu click **phpMyAdmin**

![](https://onlinesuccess.com.au/images/3b84cb494395175f7ea8928d71773a94.png)

3. On the left-hand side of the screen click on the database you just created
4. Click **Import**

![](https://onlinesuccess.com.au/images/c7afced9e38ec03be936093cebac7b04.png)

5. Under **File to import** click **Choose file**
6. Select the database file from your computer and click **Open**
7. Click **Go**
8. A green box and tick will appear saying **Import has been successfully finished, \[number] queries executed. (filename)**

## Connect your database

If you have imported your database you will need to connect it to your website.

1. In the **cPanel** main menu click **File Manager**
2. On the left-hand side of the screen, click the **public\_html** folder
3. Right-click (command-click for Mac) the **configuration file** and click **Edit** (your **configuration file** may look different to the below. The below is a WordPress website)

![](https://onlinesuccess.com.au/images/3227055d05d19a10c9dbba80913ba777.png)

4. The **Edit** menu will appear, click **Edit**
5. Where you see your current database name, username and password delete it and write your new database name, username, and password (the one you just created in cPanel)

![](https://onlinesuccess.com.au/images/fb2cfcf21f1892aed6a8d49342005f11.png)

6. Click **Save Changes**
7. Click **Close**
8. Your database is now connected to your website