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.