How to: Manage MySQL 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 it is not possible to create non-prefixed databases from within SiteWorx, users with shell access may do so from the CLI.

Contents

• How to: Manage MySQL Databases in SiteWorx

  • To Manage MySQL Databases

    • Adding a Database

    • Deleting a Database

  • To Manage MySQL Database Permissions

    • Adding Database User Permissions

    • Editing Database User Permissions

    • Deleting Database User Permissions

To Manage MySQL Databases

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 from

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

To Manage MySQL Database Permissions

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 to edit permissions for

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 Trashcan button next to the mysql user to delete permissions for. This opens the confirmation form

   

5. Click Delete