> ## Documentation Index
> Fetch the complete documentation index at: https://help.noxity.io/llms.txt
> Use this file to discover all available pages before exploring further.
# Overview
> Create databases and database users, run SQL through phpMyAdmin, and open MySQL up to remote clients.
cPanel's Databases section is where you create MySQL databases, manage the users that connect to them, and run queries through phpMyAdmin. Most apps you install through Softaculous create their own database, so you'll typically only come here when you're setting something up by hand or troubleshooting.
## What's in the Databases section
Create databases, add MySQL users, and assign privileges. The full-control tool.
A four-step guided flow that creates a database, a user, and the link between them in one go.
Whitelist external IPs so your laptop or another server can connect to MySQL.
Browse tables, run SQL, import or export dumps, and repair tables.
## How databases are named
Every database and user you create is automatically prefixed with your cPanel username and an underscore. If your account is `acme` and you type `wordpress` into the database name field, the actual database name is `acme_wordpress`. Same pattern for users: `acme_wpuser`.
This isn't optional. cPanel adds the prefix to keep account databases isolated on the shared MySQL server. Use the prefixed name (`acme_wordpress`) in your application's config file.
## Connecting from your code
For an app running on the same hosting account (WordPress, your own PHP scripts, anything in `public_html`), use these connection values:
| Setting | Value |
| -------- | ------------------------------------------- |
| Host | `localhost` |
| Port | `3306` |
| Database | The full prefixed name, e.g. `acme_wp` |
| Username | The full prefixed user, e.g. `acme_wpuser` |
| Password | The password you set when creating the user |
For connections from outside the server (your laptop, another VPS, a CI runner), see [Remote Database Access](/web-hosting/cpanel/database-management/remote-database-access).
## Common starting points
Database Wizard handles the full create-database, create-user, link-them flow in four steps.
Restore a `.sql` or `.sql.gz` file into a freshly-created database.
Dump a database to your laptop before risky changes.
Whitelist your IP and connect from MySQL Workbench, TablePlus, or DBeaver.
## Need a hand?
Best for anything that needs an account check or a config change on our end.
Faster for quick questions during business hours.