How to Create a MySQL Database in cPanel

Database, User and Privileges: The 3 Pieces

The MySQL Database Wizard does all three pieces in one pass:

1. cPanel → Databases → MySQL Database Wizard → enter a database name (your cPanel username gets prefixed: user_wp123).
2. Create the user — username and a strong password; save both immediately, they are shown once.
3. Assign ALL PRIVILEGES — tick every checkbox on the privileges screen; this is the step people skip, causing connection errors later.
4. Wire the app — put the database name, user and password into wp-config.php (or your app's config), host localhost.
5. Verify — load the site; an "error establishing database connection" points at step 3's privileges or a credential typo.

Manual creation without the wizard follows the same three pieces. Changes to config files land in the error log — the PHP error logs guide shows where to read them, and the backup guide covers protecting what you create.

Step 1: MySQL Database Wizard Walkthrough

MySQL Database Wizard Walkthrough. Do this on one site or a staging copy first, then check the public URL in a private window so cache does not hide the result. Stop if the page errors, and email support@webji.services with the step name and the exact error before you repeat it on every account. WebJi® support mail is staffed 24/7 in Hindi and English; the phone line +91 141 4941811 is business hours only.

Step 2: Assign All Privileges Correctly

Step two — assign ALL PRIVILEGES correctly, and the screen where it usually goes wrong. The non-wizard route (and the maintenance screen for later): cPanel → Databases → MySQL Databases shows two halves — databases at the top, users below — and the crucial junction is *Add User To Database*, where privileges get granted.

Select the user, submit, and on the privileges screen tick ALL PRIVILEGES for application owners; a user granted only SELECT cannot install WordPress, and a user with no grant at all produces connection refused errors that look like password typos. The checklist: database exists, user exists, user added to database, ALL PRIVILEGES ticked, credentials copied exactly — prefix included (user_wp123, not wp123). Every WordPress 'error establishing a database connection' traces back to one of those five.

Step 3: Use Credentials in wp-config.php

Use Credentials in wp-config.php. Do this on one site or a staging copy first, then check the public URL in a private window so cache does not hide the result. Stop if the page errors, and email support@webji.services with the step name and the exact error before you repeat it on every account. WebJi® support mail is staffed 24/7 in Hindi and English; the phone line +91 141 4941811 is business hours only.

Managing Databases in phpMyAdmin

On hostname localhost, the honest summary is that defaults matter more than brand names — a well-set budget plan outranks a mis-tuned premium one. WebJi® documents its defaults openly and adjusts them per ticket when workloads need it.

Remote MySQL: Allowing External Connections

Remote MySQL: Allowing External Connections. Do the change this heading names on one site first, then check it in a private browser window or in the mail client, depending on the topic. Change one setting at a time, and undo it if the result is wrong before you try the next. If you want the Jaipur desk to look with you, email support@webji.services — that mailbox is staffed 24/7 in Hindi and English. Phone +91 141 4941811 is business hours only.

Common Connection Errors Fixed

Common Connection Errors Fixed. Do the change this heading names on one site first, then check it in a private browser window or in the mail client, depending on the topic. Change one setting at a time, and undo it if the result is wrong before you try the next. If you want the Jaipur desk to look with you, email support@webji.services — that mailbox is staffed 24/7 in Hindi and English. Phone +91 141 4941811 is business hours only.