Managing Databases in Siteworx

From the SiteWorx interface, SiteWorx users can create and manage MySQL databases.

By default, all databases created in SiteWorx will be prefixed by the SiteWorx account unix username. While there it is not possible to create non-prefixed databases from within SiteWorx, users with shell access may do so from the command line. For more information, see Creating a Non-Prefixed Database User Assigned to a SiteWorx Account.

Adding a Database

1. Log into SiteWorx from the browser (https://ip.ad.dr.ess:2443/siteworx).
2. In SiteWorx, navigate to Hosting Features > MySQL > Databases, either from the side menu or SiteWorx home.

3. Click +. This opens the Add a MySQL Database dialog box.
4. Update the desired fields:

• Database Name: The name of the database. SiteWorx will automatically append the unix username of the SiteWorx to the database name provided
• Create User: Checking this box will expand the form to include database user options. Creating a database user for the new wordpress database is recommended
• Password/Confirm Password: The password for the database user. Clicking the Magic Wand will automatically generate a secure password
• MySQL User Permissions: The permissions the database user should have
• When Connecting From: The host the database user will connect from. % is the default, which is a wildcard

5. Click Add

Deleting a Database

1. Log into SiteWorx from the browser (https://ip.ad.dr.ess:2443/siteworx)
2. In SiteWorx, navigate to Hosting Features > MySQL > Databases, either from the side menu or SiteWorx home.
3. Click the Trashcan icon next to the database to delete. This opens the Confirmation form
4. Select the Confirm Action checkbox

5. Click Delete.

Adding Database User Permissions

1. Log into SiteWorx from the browser (https://ip.ad.dr.ess:2443/siteworx)
2. In SiteWorx, navigate to Hosting Features > MySQL > Databases, either from the side menu or SiteWorx home.
3. Click the Person icon button next to the Database. The opens the User Permissions page
4. Update the required fields:

• User: The user that will be added to the database
• MySQL User Permissions: The permissions the database user should have
• When Connecting From: The host the database user will connect from. % is the default, which is a wildcard

5. Click Add.

Editing Database User Permissions

1. Log into SiteWorx from the browser (https://ip.ad.dr.ess:2443/siteworx)
2. In SiteWorx, navigate to Hosting Features > MySQL > Databases, either from the side menu or SiteWorx home.
3. Click the Person icon button next to the Database. The opens the User Permissions page.
4. Under Existing Permissions, click the Pencil button next to the MySQL user for which you want to update permissions.
5. Update the desired permissions.

6. Click Save.

Deleting Database User Permissions

1. Log into SiteWorx from the browser (https://ip.ad.dr.ess:2443/siteworx)
2. In SiteWorx, navigate to Hosting Features > MySQL > Databases, either from the side menu or SiteWorx home.
3. Click the Person icon button next to the Database. The opens the User Permissions page
4. Click the Trash can button next to the mysql user to delete permissions for. This opens the confirmation form

5. Click Delete.