How to Manage MySQL Databases in SiteWorx?

Database Manipulation

How to: Add a Database

  1. Click the Hosting Features menu item if it is not already open.
  2. Click the MySQL menu item if it is not already open.
  3. Click the Databases menu item.
  4. Enter your desired database into the Database name text box.
  5. Click the Add button.

How to: Delete a Datbase

  1. Click the Hosting Features menu item if it is not already open.
  2. Click the MySQL menu item if it is not already open.
  3. Click the Databases menu item.
  4. Click the Delete button next to the Database you wish to delete.
  5. Click the Delete button under the ‘Confirm deletion of’ message.

Database Permissions

How to: Add Database Permissions

  1. Click the Hosting Features menu item if it is not already open.
  2. Click the MySQL menu item if it is not already open.
  3. Click the Databases menu item.
  4. Click the Manage Users button next to the Database you wish to edit.
  5. Select the user you wish to add permissions to from the User dropdown.
  6. Check the permissions you wish to apply to this user.
  7. Localhost can remain in the When Connecting from text box, unless you’re connecting from another computer. In that case, enter the hostname or IP address that it will be connecting from.
  8. Click the Add button.

How to: Delete Database Permissions

  1. Click the Hosting Features menu item if it is not already open.
  2. Click the MySQL menu item if it is not already open.
  3. Click the Databases menu item.
  4. Click the Manage Users button next to the Database you wish to change.
  5. Click the Delete button next to the permissions you wish to delete.
  6. Click the Delete button under the ‘Confirm deletion of’ message.

How to: Edit Database Permissions

  1. Click the Hosting Features menu item if it is not already open.
  2. Click the MySQL menu item if it is not already open.
  3. Click the Databases menu item.
  4. Click the Manage Users button next to the database you wish to change.
  5. Click the Edit button next to the permissions you wish to change.
  6. Click the boxes for the permissions you wish to change.
  7. Click the Save button.

Was this answer helpful?

 Print this Article

Also Read

Add ioncube_loader

download the correct version of ioncube here:http://www.ioncube.com/loaders.php and then create...

Manage Scheduled Tasks Via Cron in SiteWorx

How to: Update the Cron Variables Click the Hosting Features menu item if it is not...

How to Setup an SSL Chain Certificate?

A chain certificate is a digital certificate that provides a bridge of trust between a...

Setup a SSL Certificate

Prerequisites An existing SiteWorx account. A SiteWorx account with a dedicated IP address....

How to change the port InterWorx Control Panel runs on?

it should only be done in extreme cases such as if you are behind a firewall and do not have...