A MySQL database is used to store structured data for websites and applications.
Most modern websites need a database to function correctly.

Examples of data stored in a database:

• Website content such as posts and pages
• User accounts and passwords
• Settings and configuration data
• Contact form submissions
• E-commerce orders and customer data

If you are using a CMS such as WordPress, Joomla or similar software, a MySQL database is required.

Where to Find MySQL Databases in cPanel #

In cPanel, MySQL management is available under the Databases section.

You will typically see:

• MySQL Databases
• MySQL Database Wizard
• phpMyAdmin

Each tool has a specific purpose and is explained separately in other articles.

What You Can Do with MySQL Databases in cPanel #

Using the MySQL Databases section, you can:

• Create new databases
• Create database users
• Assign users to databases
• Manage database permissions
• View existing databases and users

cPanel does not automatically create databases for you unless you install software that does so.

Database Users and Permissions #

A database itself cannot be accessed without a database user.

A database user:

• Has a username and password
• Is assigned to one or more databases
• Has specific permissions such as read, write or delete

Permissions determine what the website or application is allowed to do with the data.

Incorrect permissions are a common cause of website errors.

How Websites Use MySQL Databases #

A website connects to a database using:

• Database name
• Database username
• Database password
• Database host

These details are usually stored in a configuration file, for example:

• wp-config.php for WordPress

If any of these details are incorrect, the website will not be able to connect to the database.

Common Use Cases #

You need a MySQL database when:

• Installing WordPress or another CMS
• Running a web application
• Using contact forms that store submissions
• Managing user accounts or login systems

You do not need a database for:

• Simple static HTML websites
• Websites without dynamic content

Limits and Responsibility #

Your Web Hosting or Site Hosting package defines:

• How many databases you can create
• How much storage databases may use

You are responsible for:

• Keeping database credentials secure
• Making backups of important data
• Not sharing database access with unauthorized users

ProRedLine does not modify customer databases unless explicitly requested via support.

Common Issues #

Common database-related problems include:

• Website shows “Error establishing a database connection”
• Database user not assigned to the database
• Incorrect database password
• Missing permissions

These issues are usually configuration-related and not server errors.