Overview:

Creating new databases, and database users, and assigning them in cPanel allows for proper storage, organisation, and access control of website data for security and management purposes.

Creating a new database:

1. Log in to your cPanel account.

2. In the "Databases" section, navigate to the "MySQL Databases" tool.

3. Under the "Create New Database" area, enter a name for the new database in the "New Database" field.

4. Click on the "Create Database" button.

5. The new database will now be listed in the "Current Databases" section.

   
   

Creating a new database user:

1. Log in to your cPanel account.

2. In the "Databases" section, navigate to the "MySQL Databases" tool.

3. Scroll down to the "MySQL users" section, then "Add New User" section.

4.  Enter a username and password for the new user in the "Username" and "Password" fields.

5. Click on the "Create User" button.

6. The new user will now be listed in the "Current Users" section.

It's important to note that you should choose a unique name for your database, and a strong and unique password for your user.

Assigning the user to the database:

1. Log in to your cPanel account.

2. In the "Databases" section, click on the "MySQL Databases" icon.

3. Scroll down to the "Add User to Database" section.

4. Select the user you want to add to the database, from the "User" drop-down menu.

5. Select the database that you want the user to be added to, from the "Database" drop-down menu.

6. Click on the "Add" button.

7. Select the privilege level for the user by checking the required boxes. 

8. Click on the "Make Changes" button to assign the user to the database.