Create MySQL databases and users

Shared hosting stores site data in MySQL / MariaDB. Create one database per application, then a user that can only reach that database.

Create a database

1. Open the hosting control panel from the client area.
2. Open Databases / MySQL.
3. Create a database. The panel prefixes the name with your account — copy the full name into the app config.
4. Note the database host the panel shows (often localhost on shared hosting).

Create a user

Create a database user with a strong password. Do not reuse the hosting or client-area password.

Grant, edit, or revoke permissions

1. Open the user ↔ database permissions screen.
2. Grant the user access to the new database (typically all privileges for that one database).
3. Edit later if you need a read-only user for reporting.
4. Revoke access when a user should no longer reach that database.

The application’s wp-config.php or equivalent needs the full database name, user, password, and host.

phpMyAdmin

If the panel offers phpMyAdmin (or another SQL browser), use it to inspect tables and run one-off queries. Prefer application backups and imports for large changes.

Delete a database

Download or confirm a backup first. Deleting a database removes its tables permanently.

1. Confirm no live site still points at that name.
2. Revoke users from the database if the panel asks you to.
3. Delete the database from the same MySQL list.

Open a ticket if you need a restore from a hosting snapshot after a mistaken delete.