Admin Console (Port 2087) Databases > MySQL Databases Tab 1: All Databases
BoostonCP MySQL Databases Management

MySQL Databases • Main Table Overview • Native 1920x1080 View

📌 Purpose & Quick Summary

Use the All Databases tab to create MariaDB/MySQL relational databases, create isolated database users, manage access credentials, download instant SQL backups, and monitor database storage usage.

🖥️ Interface Tour & Elements

  1. Header Action Bar: Contains the primary Create New button.
  2. Search & User Filter: Instantly search by database name or filter databases owned by a specific user.
  3. Database Directory Table:
    • Database Name: The system database identifier.
    • Database User: Associated database user with full ALL PRIVILEGES access.
    • Database Password: Password field with 1-click Eye Icon (reveal) and Copy Icon.
    • Size: Current disk space consumed by tables and indexes in MB.
    • Backup: 1-click Dump SQL icon that streams an unbuffered .sql.gz dump directly to your PC.
    • Domain: Linked website domain badge.
    • Actions Column: Change Password and Delete Database.

🛠️ Step-by-Step Instructions: Creating a New Database

  1. Navigate to Databases > MySQL Databases in the sidebar.
  2. Click the blue Create New button.
  3. In the modal:
    • Database Name: Enter the database name (e.g., wp_ecommerce).
    • Database User: Enter the username (or click auto-sync to match the database name).
    • Password: Enter a password or click the key icon to generate a strong random password.
    • Associated Domain: Select which website domain will use this database.
  4. Click Create Database. BoostonCP creates the database, assigns full privileges to localhost, and reloads the grant tables immediately.