How to create a database and database user in cPanel

Introduction

How to create and manage databases and database users in cPanel

Procedure

Create a Database

1. Login to cPanel with the cPanel username and password.
2. Click on the "MySQL Databases" icon.
3. In the "Create New Database" section, enter a database name and click Create Database.

Create a User

1. From the "MySQL Databases" page, scroll down to "MySQL Users".
2. Enter a MySQL username and password, click "Create User".

Link User to Database

1. From the "MySQL Databases" page, scroll Down to the "Add User To Database" section.
2. Select your new user and new database and click Add.
3. Put a check next to "ALL PRIVILEGES", or, optionally, select individual privileges.
4. Click "Make Changes".

Manage User Privilages

1. From the "MySQL Databases" page, scroll to the "Current Databases" section
2. Find the database you'd like to modify
3. In the "Privileged Users" section of the database entry, click the name of the user you'd like to modify
4. Put a check next to "ALL PRIVILEGES", or, optionally, select individual privileges.
5. Click "Make Changes".