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.