Assigning MySQL Profile to account when multiple exist

[holodyn]

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]

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,

 

[cPanelLauren]

The documentation should clear this up:

Manage MySQL® Profiles | cPanel & WHM Documentation

This interface allows you to manage multiple MySQL® profiles.

docs.cpanel.net

Additional MySQL Access Hosts | cPanel & WHM Documentation

This interface allows you to permit remote hosts (servers) to access MySQL® databases on your server, or to access a remote MySQL server that you configured via WHM's Manage MySQL Profiles interface.

docs.cpanel.net

Remote MySQL® | cPanel & WHM Documentation

This feature allows remote hosts (servers) to access MySQL® databases on your account.

docs.cpanel.net