Assigning MySQL Profile to account when multiple exist

holodyn

• April 02, 2020 00:25

We have a cpanel server with a local MySQL server. We have a separate MySQL database server that we have successfully connected as a remote MySQL profile within WHM. How do we / can we assign the second MySQL profile to be used by a specific account? We want specific accounts to operate on the MySQL localhost profile while other accounts operate on MySQL remote profile. While in cPanel I would expect the account specific setting applied when opening phpMyAdmin or managing databases and database users. I've looked under Modify Account and fished around in WHM and found nothing. I can't find anything online about account level profile assignment. I've attempted to change the "MYSQL.server" value in the "/var/cpanel/databases/account.json" file and that didn't seem to do anything. Are MySQL profiles designed to only be applied server wide? Only operating one at a time? This seems wrong since I can define multiple profiles... Any help or insight is appreciated. Thanks!

• 

  HostNoc

  • April 02, 2020 14:59

  Hello @holodyn The Mysql Profile in WHM is giving the option to add and access another mysql server and the authentic credentials can also be added there. You need to grant privileges on the remote Mysql Database Server with all access to the cPanel Server. Furthermore, also the IP of the cPanel server address will be bind in the Mysql Database Server's my.cnf Regards,

  0
• 

  cPanelLauren

  • April 02, 2020 18:33

  The documentation should clear this up:

  0

Please sign in to leave a comment.