How to Create and Maintain MySQL Databases in cPanel

Author:Fraser Lennox
Updated:Aug 13, 2025

To create a MySQL database and user in cPanel, follow these organized steps:

  1. Log into cPanel: Access your hosting account via cPanel using your credentials.

  2. Locate the MySQL Database Wizard:

    • Navigate to the Databases section in cPanel.
    • Click on the "MySQL Database Wizard" option.
  3. Create the Database:

    • Enter a unique database name (e.g., myfirstdb).
    • Click "Next Step."
  4. Set Up the User:

    • Provide a username (e.g., myfirstuser).
    • Create a strong password (e.g., P@ssw0rd2023).
    • Click "Create User."
  5. Assign Privileges:

    • Select "All Privileges" to grant full access.
    • Click "Next Step."
  6. Confirm the Addition:

    • After creation, review the Databases section in cPanel.
    • Ensure your database (myfirstdb) and user (myfirstuser) are listed.
  7. Secure Your Password:

    • Store the password securely using a password manager to avoid forgetting it.
  8. Check for Edits:

    • If needed, reset the password via cPanel after initial creation.