» How do I create a new database?

 

To create a new MySQL database in Control Web Panel (CWP), log in and navigate to SQL Services > MySQL Manager, then click Create Database and User. Enter a database name, username, and password, then click Create Database to complete the setup for your application.

Steps to Create a Database in CWP:

  1. Log in to CWP: Access your control panel (usually port 2030 or 2031).
  2. Access MySQL Manager: In the left sidebar, click SQL Services, then select MySQL Manager.
  3. Create Database & User: Click on the Create Database and User button.
  4. Fill Details:
    1. New Database for user: Choose the account owner.
    2. Database Name: Enter a name (e.g., user_dbname).
    3. Database User: Create a username.
    4. Password: Set a strong password. 
  5. Save: Click the Create Database button.

Important Notes:

  • Prefix: CWP typically prefixes databases with the username (e.g., username_db).
  • Alternatives: You can select Create only Database if you wish to add a user later.
  • phpMyAdmin: Use SQL Services > phpMyAdmin to manage tables within your new database.

 

Was this answer helpful?

Add to favorites Add to Favourites
Print Print this Article