Knowledgebase

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.