---
title: "How to create MySQL databases with SiteWorx"
source: "https://docs.nexcess.com/sites-stores/control-panel/interworx/siteworx/database-management/create-mariadb-mysql-databases/"
description: "How Nexcess clients on physical (non-cloud) servers can use the SiteWorx control panel to create a MySQL database."
vertical: "Sites & Stores"
date: "2019-09-10"
last_modified: "2026-07-02"
---

# How to create MySQL databases with SiteWorx

## Creating databases and users

If you are not the administrator, your SiteWorx user account must have the appropriate permissions to execute the below procedure. Contact your administrator and refer to [How to add secondary users to your SiteWorx account](https://docs.nexcess.com/sites-stores/control-panel/interworx/siteworx/database-management/user-accounts/) for more information.

After creating your database, you may perform administrative functions by [launching phpMyAdmin from the SiteWorx control panel](https://www.liquidweb.com/blog/what-is-phpmyadmin/).

1. Log in to your SiteWorx account.
    
    
    - If you do not know your password, click **Forgot your password** on the login page.
2. From the SiteWorx main menu, click **Hosting Features > MySQL > Databases**.
3. In the **Database Name** field, type the name of the new database. Do not use spaces or special characters, although you may use “\_” to indicate a space, if necessary.
4. Click the **Create User** check box.
5. The menu will expand, allowing you to configure login credentials and assign permissions.
6. If successful, the new database will appear in the Existing Databases section. 
    - SiteWorx automatically prefixes your assigned database name with the first eight characters of your domain name, followed by an underscore.
    - When specifying database information for other applications, you must use this entire name.
7. If you want to create additional users for a database, refer to [How to create MySQL database user accounts in SiteWorx](https://docs.nexcess.com/sites-stores/control-panel/interworx/siteworx/database-management/user-accounts/).

## MySQL database user permissions

The following table defines the available permissions that can be applied to a specific MySQL Database user account.

| User Permissions | Operations Allowed |
|---|---|
| **Select** | Select rows from tables in the database. |
| **Create** | Create new databases or tables. |
| **Alter** | Alter the table structure. |
| **Show View** | Show views. |
| **Insert** | Insert rows into tables. |
| **Drop** | Drop or remove existing databases and tables. If this permission is enabled, the user can drop the database storing the MySQL access privileges for a user. |
| **Create Temporary Table** | Create temporary tables. |
| **Create Routine** | Create stored routines, procedures, and functions. |
| **Update** | Update database table rows and data. |
| **References** | Not currently in use. |
| **Lock Tables** | Lock tables in the database. |
| **Alter Routine** | Modify or alter stored routines. |
| **Delete** | Delete data and rows in database tables |
| **Index** | Create or remove indexes. |
| **Create View** | Create a new view. |
| **Execute** | Execute stored routines, procedures, and functions. |