How to: Create Non-Prefixed Databases and Users 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.

Note

This feature does not need to be enabled for non-prefixed cPanel databases to import correctly.

Contents

• How to: Create Non-Prefixed Databases and Users Assigned to a SiteWorx Account

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

  • Creating A Non-Prefixed Database Assigned to a SiteWorx Account

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

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

1. Log in to the server at the CLI as root, either via SSH or from the terminal

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, either via SSH or from the terminal

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 Assigned to a SiteWorx Account

Note

Once the user is created, permissions will need to be granted for the user from SiteWorx, under Hosting Features > MySQL > Databases

1. Log in to the server at the CLI as root, either via SSH or from the terminal

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