How To: Manage MySQL Databases

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

  • To Manage MySQL Databases

    • Adding a Database

      • From the Databases Page

      • From the Add a MySQL Database Icon

    • Deleting a Database

      • From the Database List

      • From the With Selected Dropdown

  • To Manage MySQL Database Permissions

    • Adding Database User Permissions

    • Editing Database User Permissions

    • Deleting Database User Permissions

To Manage MySQL Databases

Adding a Database

From the Databases Page

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 + or Add a MySQL Database. This opens the Add a MySQL Database form

   

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

From the Add a MySQL Database Icon

1. Log into SiteWorx from the browser (https://ip.ad.dr.ess:2443/siteworx)

2. In SiteWorx, click Add a MySQL Database. This opens the Add a MySQL Database form

   

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

4. Click Add

Deleting a Database

From the Database List

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

From the With Selected Dropdown

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. Select the checkbox next to the database(s)

   • Selecting the checkbox next to the With Selected dropdown will automatically select all databases

4. Select Delete from the With Selected dropdown

5. Click Go. This opens the Confirm Deletion form

   

6. 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 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. This opens the MySQL User Permissions form

   

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. This opens the confirmation form

   

5. Click Delete