How to Create MySQL Database

Introduction

A MySQL database stores website data such as:

WordPress content
User accounts
Website settings
Orders and customer information
Application data

Most PHP applications like WordPress, Laravel, Joomla, Magento, and WHMCS require a MySQL database.

cPanel allows you to easily create and manage MySQL databases.

What You Need Before Creating a Database

Before starting, ensure you have:

Active hosting account
cPanel access
Application requiring database support

Step 1: Log in to cPanel

Open your cPanel login URL:

https://yourdomain.com:2083

or access through:

https://my.govaio.com/login

Enter your cPanel username and password.

Step 2: Open MySQL Databases

After logging in:

Navigate to the Databases section
Click:

MySQL Databases

Understanding MySQL Components

Before creating the database, it is important to understand:

Component	Purpose
Database	Stores website/application data
Database User	Account used to access database
Privileges	Permissions granted to user

Step 3: Create New Database

Under Create New Database:

Enter database name.

Example:

website_db

Click:

Create Database

Database Naming Format

Most cPanel servers automatically prefix database names with your cPanel username.

Example:

cpaneluser_website_db

Step 4: Create MySQL User

Scroll to:

MySQL Users

Enter:

Field	Example
Username	website_user
Password	StrongPassword@123

Generate Strong Password

Use the Password Generator for better security.

Recommended password features:

Uppercase letters
Lowercase letters
Numbers
Symbols

Click:

Create User

Step 5: Add User to Database

Under:

Add User To Database

Select:

Database User
Database Name

Click:

Add

Step 6: Assign Database Privileges

Select required permissions.

For most applications, select:

ALL PRIVILEGES

Then click:

Make Changes

Your Database is Ready

You now have:

MySQL Database
Database User
Database Password
User privileges configured

Example Database Credentials

Setting	Example
Database Name	cpaneluser_website_db
Database User	cpaneluser_website_user
Password	YourPassword
Database Host	localhost

Common Database Host

Most cPanel hosting servers use:

localhost

How to Use Database in Applications

Applications like WordPress require database details during installation.

Example:

Field	Value
Database Name	cpaneluser_website_db
Username	cpaneluser_website_user
Password	YourPassword
Host	localhost

How to Access phpMyAdmin

phpMyAdmin allows you to manage databases visually.

Open phpMyAdmin

Go to cPanel
Open:

phpMyAdmin

You can:

Import databases
Export backups
Run SQL queries
Edit tables

How to Import SQL Database

Steps:

Open phpMyAdmin
Select database
Click:

Import

Upload .sql file
Click:

Go

How to Export Database Backup

Steps:

Open phpMyAdmin
Select database
Click:

Export

Choose format:
- SQL
Download backup

Common MySQL Errors & Solutions

1. Access Denied Error

Cause:

Wrong username/password or missing privileges.

Solution:

Verify credentials
Reassign privileges

2. Database Connection Failed

Cause:

Incorrect database host or credentials.

Solution:

Verify:
- Database name
- Username
- Password
- Host

3. Too Many Connections

Cause:

High database usage.

Solution:

Optimize queries
Upgrade hosting plan if needed

4. Import Size Limit Error

Cause:

Large SQL file.

Solution:

Compress SQL file
Use SSH or BigDump for large imports

Security Recommendations

Use strong database passwords
Remove unused database users
Limit database privileges where possible
Regularly backup databases
Avoid sharing database credentials publicly

Frequently Asked Questions (FAQ)

Q1. What is MySQL used for?

MySQL stores website and application data dynamically.

Q2. What is database host in cPanel?

Usually:

localhost

Q3. Can I create multiple databases?

Yes. Most hosting plans allow multiple databases.

Q4. Where can I manage databases visually?

Using:

phpMyAdmin

inside cPanel.

Q5. Is MySQL required for WordPress?

Yes. WordPress requires a MySQL database.

Need Help?

If you need assistance creating or managing MySQL databases, contact support:

📧 support@govaio.com