Note

You are viewing the documentation for an older release of Interworx (6.x). To see documentation for the current generally available release of Interworx, click here: 7.13.

Non-prefixed MySQL Database Names and MySQL User Names, DB mapping

CLI based creation of non-prefixed MySQL \ Mariadb database and user names.

First: Enable CLI based no prefix’s:

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

Please note, this feature does not need to be enabled for non-prefixed cPanel databases to import without prefixing, this will happen regardless of this feature setting.

Then use the CLI to add the db and db user.

Example, add a non-prefixed db.

siteworx -u -n --login_domain=example.com -c MysqlDb -a addFQ --name wordpress

Example, add a non_prefix’d user db.

siteworx -u -n --login_domain=$domain -c MysqlUser -a addFQ --name $dbusername --password '$password' --confirm_password '$password' -n

Finally use the UI or CLI to add permissions for the db user to the db. Currently there is no UI for adding or mapping non prefix’d dbs or users.