Nexcess Logo

How to create MySQL databases with SiteWorx

Knowledge Base Home

Notice anything different?

We've enhanced the appearance of our portal and we're working on updating screenshots. Things might look different, but the functionality remains the same.
September 10, 2019

How Nexcess clients on physical (non-cloud) servers can use the SiteWorx control panel to create a MySQL database.

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 for more information.

After creating your database, you may perform administrative functions by launching phpMyAdmin from the SiteWorx control panel.

  1. Log in to your SiteWorx account.

  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.

      1. In the Username field, enter the desired username. You must use one word of no more than seven characters, though you may include a “_” to indicate a space, if desired.

      2. To choose the password, choose one of the following:

        • Create your own password by typing it into both the Password and Confirm Password fields. For security tips and general advice about password creation, refer to How to create a secure password.

        • Either enter a password or click Generate to have SiteWorx create one for you. 

      3. Assign permissions as desired. By default, all permissions are enabled; clear each check box to remove permissions as necessary.

      4. In the When Connecting From field, specify the hostname from which the user must connect to the database. If you are unsure, leave it blank.

      5. Click Add.

  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.

MySQL database user permissions

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

User PermissionsOperations Allowed
SelectSelect rows from tables in the database.
CreateCreate new databases or tables.
AlterAlter the table structure.
Show ViewShow views.
InsertInsert rows into tables.
DropDrop 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 TableCreate temporary tables.
Create RoutineCreate stored routines, procedures, and functions.
UpdateUpdate database table rows and data.
ReferencesNot currently in use.
Lock TablesLock tables in the database.
Alter RoutineModify or alter stored routines.
DeleteDelete data and rows in database tables
IndexCreate or remove indexes.
Create ViewCreate a new view.
ExecuteExecute stored routines, procedures, and functions.

For 24-hour assistance any day of the year, contact our support team by email or through your Client Portal.

Jason Dobry
We use cookies to understand how you interact with our site, to personalize and streamline your experience, and to tailor advertising. By continuing to use our site, you accept our use of cookies and accept our Privacy Policy.