Description: This article explains how to create and manage databases in SiteWorx, including setting up database users and permissions.

Managing databases within SiteWorx typically involves working with MySQL or MariaDB. Here's a breakdown of how to create and manage databases, users, and permissions:

1. Accessing the MySQL/MariaDB Section:

• Log in to SiteWorx:
  • Begin by logging into your SiteWorx control panel.
• Navigate to MySQL/Databases:
  • Look for the "Hosting Features" section, and then select "MySQL" or "Databases."

2. Creating a Database:

• Find the "Create Database" Option:
  • Within the MySQL/Databases section, there will be an option to create a new database.
• Enter Database Details:
  • You'll need to provide a database name. Be aware that SiteWorx may automatically prefix your database name with a portion of your account or domain name.
  • In many cases, the creation process will also allow you to create a database user at the same time.
• Complete Creation:
  • Follow the on-screen prompts to finalize the database creation.

3. Creating a Database User:

• Access the "Users" Section:
  • In the MySQL section, there should be a separate area for managing database users.
• Add a New User:
  • Click the option to add a new database user.
• Enter User Details:
  • Provide a username and a strong password.
• Assign Database Permissions:
  • This is a crucial step. You'll need to assign the appropriate permissions to the user, such as:
    • SELECT: Allows the user to retrieve data.
    • INSERT: Allows the user to add data.
    • UPDATE: Allows the user to modify data.
    • DELETE: Allows the user to remove data.
    • CREATE: Allows the user to create tables.
    • DROP: Allows the user to delete tables.
    • And other permissions.
  • It is best practice to give users the least amount of privileges that they need to accomplish their tasks.
• Specify Host Access:
  • You may need to specify the host from which the user can connect (e.g., "localhost" for local connections, or a specific IP address or "%" for any host).
• Complete User Creation:
  • Save the user settings.

4. Managing Database Users and Permissions:

• Edit User Permissions:
  • You can modify the permissions assigned to a database user at any time.
• Delete Users:
  • If a user is no longer needed, you can delete them.
• Access phpMyAdmin:
  • SiteWorx often provides access to phpMyAdmin, a web-based tool for managing MySQL/MariaDB databases. This tool offers advanced database management capabilities.

Important Considerations:

• Security:
  • Use strong, unique passwords for all database users.
  • Grant only the necessary permissions to each user.
  • Keep your database software up to date.
• Database Naming:
  • Be aware of any naming conventions imposed by SiteWorx.
• Backup:
  • Regularly back up your databases to prevent data loss.
• Documentation:
  • The interworx documentation is a great source of information.

By following these steps, you can effectively create and manage your databases within SiteWorx.