How do I create a MySQL database in cPanel? Print

WebHost4life linux webhosting is using cPanel control panel and here in this article we will show you how you can create a new database in your cPanel, assign a user to it and grant full privileges for the user to the database in question.

To proceed, please follow the instructions below:

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