• Pricing
  • Features
    • InterWorx
    • Clustering
    • Developers
    • Roadmap
  • Support
    • Overview
    • Latest News and Blog
    • Documentation
    • InterWorx Forums
    • Version History
    • Help Desk
    • FAQ’s
    • Feedback and Feature Requests
  • Company
    • End User License Agreement
    • Privacy Policy
    • Bug Bounty
    • InterWorx Partners
    • Our Brand
    • Website Accessibility Statement
    • Contact Us
  • My Account
InterWorx Control Panel Supported Distro Guide
November 15, 2012
How to: Manage Custom Port Access Rules for Firewall
November 15, 2012

How to: Manage MySQL Databases in SiteWorx

Published by InterWorx on November 15, 2012

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 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. 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.
Share
2

Related posts

July 3, 2020

How to Install and Use the CloudLinux Plugin for InterWorx


Read more
April 10, 2020

How to Install and Use the Acronis Plugin for InterWorx


Read more
December 11, 2019

Non-prefixed MySQL Database Names and MySQL User Names, DB mapping


Read more
  • Liquid Web Family of Brands
  • Liquid Web
  • Visit Nexcess
  • Visit iThemes
  • Visit Interworx
© 2019 InterWorx, LLC. All Rights Reserved.
      We use cookies to understand how you interact with our site, to personalize and streamline your experience, and to tailor advertising. By continuing to use our site, you accept our use of cookies and accept our Privacy Policy.