How to create and manage MySQL Databases in cPanel Print

The vast majority of modern web applications (such as WordPress, Joomla, Magento, or custom PHP scripts) rely on a robust database layout to store text layouts, core variables, customer records, and product assets. cPanel utilizes the MySQL / MariaDB platform engine to secure this environment structure.

To connect a website script to your cloud node, you must perform three clean tasks: provision a new database container, create an authorized service user, and link that database user to the container with full execution privileges.

Step-by-Step Database & User Configuration:

1. Provision the New Database

1. Log in to your cPanel administrative command center.
2. Under the "Databases" application framework, click on MySQL Databases.
3. Inside the New Database input box, type your target label string (e.g., wpprod).
4. Click the Create Database button. The system registers a complete name index syntax like cpaneluser_wpprod. Copy this string down.

2. Create the Security MySQL User

1. On that exact same configuration window, scroll down to the MySQL Users - Add New User workspace block.
2. In the Username input box, type your service moniker (e.g., wpuser).
3. In the Password field boxes, assign a robust password credentials key (we highly suggest deploying the integrated random generator link). Keep this token safe, as your site configuration scripts require it.
4. Click Create User. Your operational identifier maps out as cpaneluser_wpuser.

3. Map the User to the Database (Crucial Action Step)

Bypassing this step triggers the infamous "Error Establishing a Database Connection" fault line. You must map permissions for the user interface:

1. On the same workspace layout, scroll to the Add User To Database grid.
2. From the User dropdown selection layout, choose the account moniker you just deployed.
3. From the Database dropdown list, choose the corresponding container name.
4. Click the Add button.
5. On the next dashboard modal view, toggle the ALL PRIVILEGES checkbox to award complete operational control to your script engine.
6. Click Make Changes at the footer interface row to commit the settings.

How to Access Internal Table Records (phpMyAdmin)

Should your developer require exporting a structured database backup file, importing a clean .sql script dump, or modifying structural tables manually:

1. Navigate back to your primary cPanel landing deck index.
2. Under the "Databases" block row, launch the phpMyAdmin tool application.
3. This integrated software interface grants you visual mechanics to inspect table data fields, stream direct SQL queries, and carry out advanced database optimizations.