How to Access cPanel and Host a MySQL Database

How to Access HostGraber cPanel and Host a MySQL Database

This guide explains how to log in to HostGraber cPanel and create/manage MySQL databases. You can use this as reference documentation or publish it in your knowledge base.

Accessing HostGraber cPanel

Follow these steps to log in to your cPanel account:

1. Open your preferred web browser.
2. Enter the cPanel login URL:

• http://yourdomain.com/cpanel
• or http://SERVER-IP:2083

Creating and Managing a MySQL Database in cPanel

Step 1: Create a New Database

1. Log in to cPanel.
2. Navigate to MySQL® Databases.
3. Under Create New Database, enter a name for your database.
4. Click Create Database.

Step 2: Create a Database User

1. In the same section, scroll to MySQL Users.
2. Enter the desired username and a secure password.
3. Click Create User.

Step 3: Assign User to Database

1. Scroll down to Add User to Database.
2. Select the newly created user and the database.
3. Click Add.
4. Select All Privileges to grant full access.
5. Click Save.

Step 4: Collect Database Connection Details

You will need the following information to connect your application:

• Database Name
• Database User
• Database Password
• Database Host (usually localhost)

Connecting Your Application to the Database

Use this standard connection format in your configuration file:

DB_HOST=localhost

DB_USER=your_user

DB_PASSWORD=your_password

DB_NAME=your_database

For further assistance, feel free to contact HostGraber Support.