Creating a Non-Prefixed Database User Assigned to a SiteWorx Account

While InterWorx allows the ability for SiteWorx accounts to use non-prefixed databases and database users, it is currently not possible to create non-prefixed databases, or non-prefixed users, from the SiteWorx interface.
However, it is possible to create non-prefixed databases and database users and automatically assign them to a SiteWorx account from the CLI.

Enabling Permission to Create Non-Prefixed Databases and Users Using the InterWorx CLI

1. Log in to the server at the CLI as root via SSH. For help using SSH, see Logging into Your Server via Secure Shell (SSH).
2. At the CLI, run the following command. This enables the enable_no_prefix_api flag in ~iworx/iworx.ini, which allows non-prefixed databases and users to be created via the InterWorx CLI:

~iworx/bin/ini.pex --set --section="mysql" --index="enable_no_prefix_api" --value="1"

Creating A Non-Prefixed Database Assigned to a SiteWorx Account

1. Log in to the server at the CLI as root via SSH. For help using SSH, see Logging into Your Server via Secure Shell (SSH).
2. At the CLI, run the following one liner, replacing the variables in the {} with the corresponding values.This creates the database and automatically assigns it to the specified SiteWorx account:

siteworx -u -n --login_domain {domain}  -c MysqlDb -a addFQ --name {database name}

Creating a Non-Prefixed Database User for a Database

1. Log in to the server at the CLI as root via SSH. For help using SSH, see Logging into Your Server via Secure Shell (SSH).
2. At the CLI, run the following one line, replacing the variables in the {} with the corresponding values. This creates the database user and automatically assigns it to the specified SiteWorx account:

siteworx -u -n --login_domain {domain} -c MysqlUser -a addFQ --name {dbusername} --password '{password}' --confirm_password '{password}' -n