📌 Purpose & Quick Summary

The MySQL Databases hub enables you to provision and manage high-performance relational databases powered by MariaDB. You can create isolated databases, configure database user credentials with automated strong password generation, grant granular privileges, and launch phpMyAdmin with 1-click Single Sign-On (SSO) without re-entering passwords.

BoostonCP MySQL Databases Overview

Figure 9: Relational Assets dashboard showing provisioned databases, disk size, user assignments, and phpMyAdmin SSO.

🖥️ Interface Tour & Elements

  1. Create Database Action Button: Opens the database provisioning modal to configure database name, username, and password.
  2. phpMyAdmin Single Sign-On (SSO) Button: Prominent navigation button that establishes an authenticated session and opens phpMyAdmin directly in a new browser tab.
  3. Database Ledger Table:
    • Database Name: Prefixed with your account username (e.g. user_dbname).
    • Database User: Associated database user account.
    • Size on Disk: Current storage consumed by tables and indexes.
    • Action Controls: 1-click buttons to Rotate Password, download a direct SQL Export, or Drop Database.

🛠️ Step-by-Step Instructions

Step 1: Provisioning a New Database

  1. In the sidebar, click MySQL Databases (icon: fa-database).
  2. Click the Create Database button.
  3. In the modal dialog:
    • Database Name: Enter a descriptive suffix (e.g. shop -> full name: user_shop).
    • Database User: Enter a username (or check Use same name for user).
    • Password: Click the Generate Password button and copy the secure string.
  4. Click Create Database. The MariaDB server provisions the schema, assigns ALL PRIVILEGES to the user, and flushes privileges instantly.

Step 2: Accessing phpMyAdmin via SSO

  1. In the top toolbar, click Launch phpMyAdmin.
  2. BoostonCP generates an ephemeral authentication handshake token.
  3. phpMyAdmin opens immediately in a new tab, granting full access to your databases without prompting for manual database credentials.

Step 3: Rotating Database User Password

  1. Locate the database in the ledger table.
  2. Click the Change Password (key icon) button.
  3. Generate a new password, copy it, and click Update Password.
  4. Remember to update your CMS configuration file (e.g. wp-config.php or .env) with the new password.

⚙️ Complete Field & Parameter Reference Table

Parameter Format / Value Description & Technical Specifics
Database Host localhost or 127.0.0.1 Local UNIX socket or loopback interface connection.
Port 3306 Standard MariaDB/MySQL network listener port.
Database Name prefix_dbname Fixed account prefix enforced for multi-tenant isolation.
Database User prefix_dbuser MySQL user granted permissions exclusively to this database.
Collation utf8mb4_unicode_ci Modern full 4-byte UTF-8 encoding supporting emojis and all character sets.
phpMyAdmin SSO Ephemeral token Zero-credential Single Sign-On authenticated via BoostonCP session.

❓ Troubleshooting & Common Errors

1. Error: "Access denied for user 'user_db'@'localhost'"

  • Cause: Typo in database username or password in your website's configuration file (wp-config.php, .env), or user was deleted.
  • Solution: Open the database in the panel, click Change Password, set a new password, and verify that the exact string is pasted into your application config.

2. phpMyAdmin Displays "Session Expired"

  • Cause: Closing the control panel session invalidates the SSO handshake token.
  • Solution: Return to the BoostonCP User Panel, navigate to MySQL Databases, and click Launch phpMyAdmin to issue a fresh SSO session.