Assigning MySQL Profile to account when multiple exist

holodyn

Member
Feb 6, 2008
5
1
53
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

Active Member
Feb 20, 2020
28
3
3
Ontario
cPanel Access Level
Root Administrator
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

Product Owner
Staff member
Nov 14, 2017
13,296
1,261
313
Houston
The documentation should clear this up: