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

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

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.