• Pricing
  • Features
    • InterWorx
    • Clustering
    • Developers
    • Roadmap
  • Support
    • Overview
    • Latest News and Blog
    • Documentation
    • InterWorx Forums
    • Version History
    • Help Desk
    • FAQ’s
    • Feedback and Feature Requests
  • Company
    • End User License Agreement
    • Privacy Policy
    • Bug Bounty
    • InterWorx Partners
    • Our Brand
    • Website Accessibility Statement
    • Contact Us
  • My Account
Cloudflare partners plugin and Real Visitor IP Logging
December 6, 2019
How to Install and Use the Acronis Plugin for InterWorx
April 10, 2020

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

Published by InterWorx on December 11, 2019

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.

Share
5

Related posts

July 3, 2020

How to Install and Use the CloudLinux Plugin for InterWorx


Read more
April 10, 2020

How to Install and Use the Acronis Plugin for InterWorx


Read more
December 6, 2019

Cloudflare partners plugin and Real Visitor IP Logging


Read more
  • Liquid Web Family of Brands
  • Liquid Web
  • Visit Nexcess
  • Visit iThemes
  • Visit Interworx
© 2019 InterWorx, LLC. All Rights Reserved.
      We use cookies to understand how you interact with our site, to personalize and streamline your experience, and to tailor advertising. By continuing to use our site, you accept our use of cookies and accept our Privacy Policy.