> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://docs.clientexec.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# How To Create a Database

This guide will help you create a database for Clientexec. Depending on your server configuration, there are multiple ways of doing this. This tutorial will show how to create a database through **cPanel**, how to manually create one via **PHPMyAdmin** and how to create one in **Plesk**.

### Method 1 - cPanel Database Creation

1. Login to your cPanel.
2. Navigate to the MySQL® Database Wizard. 

![](https://storage.crisp.chat/users/helpdesk/website/895a2775afb3f800/database1_1my0j2f.png)

3. Create your database name.

![](https://storage.crisp.chat/users/helpdesk/website/895a2775afb3f800/database2_1350jpv.png)

4. Click Next Step.
5. Create your database's username and password. 

![](https://storage.crisp.chat/users/helpdesk/website/895a2775afb3f800/database3_1hp424i.png)

6. Click Create User.
7. Click ALL PRIVILEGES.

![](https://storage.crisp.chat/users/helpdesk/website/895a2775afb3f800/database4_jaxsla.png)

8. Click Next Step. 
9. Your database has now been created. Be sure to notate the information you entered as it will be asked for during the installation process.

### Method 2 - PHPMyAdmin Database Creation

1. Navigate to **PHPMyAdmin**.
2. Click **Databases**. 

![](https://storage.crisp.chat/users/helpdesk/website/895a2775afb3f800/p1_1n0ajbd.png)

3. Specify a database name, then click **Create**. 

![](https://storage.crisp.chat/users/helpdesk/website/895a2775afb3f800/p2_e3up81.png)

4. The database has been created; it should instantly appear in the list below the creation section. Click **Check Privileges** to the far right. 

![](https://storage.crisp.chat/users/helpdesk/website/895a2775afb3f800/p3_e32ba8.png)

5. Click **Add User**. 

![](https://storage.crisp.chat/users/helpdesk/website/895a2775afb3f800/p4_a0fbb1.png)

6. Fill in the database user information. On the Host tab, unless the server configuration is different, Local can be selected which will autofill the field with **localhost**. Click **Check All** on the **Global Privileges** area. 

![](https://storage.crisp.chat/users/helpdesk/website/895a2775afb3f800/p5_4v2lg6.png)

8. Click **Add User**.
9. You have successfully created a database and created a database user with full access to our database.

### Method 3 - Plesk Database Creation

*Note: we are using Service Provider View for these instructions.*

1. Login to your **Plesk**.
2. Go Domains and select the Website where you wish to install Clientexec. 
3. Select **Databases**.

![](https://storage.crisp.chat/users/helpdesk/website/895a2775afb3f800/plesk1bdpoar_1ch53de.png)

4. Click the **Add Database** button.

![](https://storage.crisp.chat/users/helpdesk/website/895a2775afb3f800/adddb_m46rnv.png)

5. Fill out the information for your new **Database**.

![](https://storage.crisp.chat/users/helpdesk/website/895a2775afb3f800/adddb2_2j3oxo.png)

* **Database Name**: enter the name for your new Clientexec database.
* **Related Sites**: in the dropdown, select the domain where your Clientexec will be hosted.
* **Database Username**: create a username for your database.
* **Password**: create a Password for your database.
* **Confirm Password**: confirm the password you created. 

6. Press the **OK** button.
7. Your database has now been created. Be sure to notate the information you entered as it will be asked for during the installation process.