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::

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

#. Log in to the server at the CLI as root, either via SSH or from the terminal
#. 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:

   .. code-block::

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

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

#. Log in to the server at the CLI as root, either via SSH or from the terminal
#. 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: 

   .. code-block::

      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** 

#. Log in to the server at the CLI as root, either via SSH or from the terminal
#. 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:

   .. code-block::

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