A MySQL database is required for many websites and applications, such as WordPress, Joomla, Drupal, and other content management systems. Databases store important information like website content, user accounts, and settings.

This guide explains how to create a MySQL database in cPanel.

Step 1: Log in to cPanel

1. Open your web browser.

2. Go to your cPanel login page.

Example:

https://yourdomain.com/cpanel

3. Enter your cPanel username and password.

4. Click Log in.

Step 2: Open the MySQL Databases Tool

1. Scroll down to the Databases section.

2. Click MySQL Databases.

This page allows you to create and manage databases and database users.

Step 3: Create a New Database

1. Under Create New Database, enter a name for your database.

Example:

mydatabase

2. Click Create Database.

Your database will now be created.

Note: cPanel automatically adds your account prefix to the database name.
Example: cpanelusername_mydatabase

Step 4: Create a Database User

Next, create a user that will have permission to access the database.

1. Scroll down to the MySQL Users section.

2. Under Add New User, enter the following:

• Username – the database user name

• Password – create a strong password or click Generate Password

Example username:

dbuser

3. Click Create User.

Step 5: Assign the User to the Database

After creating the user, you must connect it to the database.

1. Scroll down to Add User to Database.

2. Select the User you created.

3. Select the Database you created.

4. Click Add.

Step 6: Set User Privileges

1. Select All Privileges to allow the user full access to the database.

2. Click Make Changes.

Your database and user are now fully configured.

Using the Database with Your Website

When installing a script or application, you will usually need to provide the following information:

• Database Name

• Database Username

• Database Password

• Database Host (usually localhost)

These details allow the application to connect to the database.

Managing Your Database

You can manage your database using phpMyAdmin in cPanel.

phpMyAdmin allows you to:

• View database tables

• Edit records

• Import or export databases

• Run SQL queries

• Create backups

To access it:

1. Go to the Databases section in cPanel.

2. Click phpMyAdmin.

Tips for Database Management

• Use strong passwords for database users.

• Keep regular database backups.

• Avoid deleting databases unless you are sure they are no longer needed.

• Record your database credentials when installing applications.

If you need assistance creating or managing a MySQL database, please contact our support team and include any error messages or screenshots so we can assist you further.