How to create MySQL database user accounts in SiteWorx

How can we help you?

What you need

A Nexcess account on a physical (non-cloud) server. If you are a Nexcess Cloud client, instead contact our 24/7 support team by email or through the Client Portal for assistance.

If you do not know your password, click Forgot your password on the login page.
If you do not know the web address for your SiteWorx login page, either refer to your Welcome Email or contact our support team.

If you are a secondary user on another person's SiteWorx account, your user account must be have permission to create MySQL databases.

If you want a SiteWorx user other than yourself to manage databases through your SiteWorx account, you must first configure a secondary SiteWorx user account, assign the user to a database, and assign the appropriate permissions as directed below.

1: Create the user

As an alternative means of user creation, you can create the user during the creation of the database; see How to create MySQL databases with SiteWorx.

From the SiteWorx main menu, click Hosting Features > MySQL > Users.

In the MySQL Database User Management section, enter a username and password:

ATTENTION: SiteWorx automatically prefixes the database user name with the first eight characters of your domain name. For example, for user jdoe at example.com, the name will appear as examplec_jdoe. If you are configuring an application that will be using one of your MySQL databases, specify the complete database and database user name.

For the password, either enter your own or click Generate to have SiteWorx create one for you. If you did not choose to generate a password, you must enter the password again in the Confirm Password field.
Note of the password; you will reference it when preparing applications to use this database.

Click Add. The new user will appear in the Existing MySQL User section below.

Proceed to the next section.

2: Assign the user to a database

In the SiteWorx main menu, select Hosting Options > MySQL > Databases.

In the Existing Databases section, locate the desired database and select Manage Users.

From the User drop-down menu, select the appropriate user.

By default, all permission check boxes are selected. To remove a permission, clear the corresponding check box. Refer to the Table 1 in the Permissions section below for more information.

In the When Connecting From field, either leave it empty to allow the user to connect from any hostname, or specify the hostname the user must connect from.

Click Add.

List of available permissions

The following table defines the available permissions for application to a MySQL user. The order in which the permissions are listed reflects the order in which they are provided on the SiteWorx MySQL Database Management menu.

User Permission	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 (remove) existing databases and tables. If this permission is enabled for a user, the user will be able to drop the database in which the MySQL access privileges are stored .
Create Temporary Table	Create temporary tables
Create Routine	Create stored routines (procedures and functions)
Update	Update database table rows/data
References	Not currently used
Lock Tables	Lock tables in the database
Alter Routine	Modify (alter) stored routines
Delete	Delete data/rows in database tables
Index	Create or remove indexes
Create View	Create a new view
Execute	Execute stored routines (procedures and functions)

User Permission

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 (remove) existing databases and tables. If this permission is enabled for a user, the user will be able to drop the database in which the MySQL access privileges are stored .

Create Temporary Table

Create temporary tables

Create Routine

Create stored routines (procedures and functions)

Update

Update database table rows/data

References

Not currently used

Lock Tables

Lock tables in the database

Alter Routine

Modify (alter) stored routines

Delete

Delete data/rows in database tables

Index

Create or remove indexes

Create View

Create a new view

Execute

Execute 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.

How can we help you?