Adding RDS server to WHM

oah

• August 28, 2018 19:54

Hi I am using "AMAZON 2018.03 xen hvm [host] with WHM,v74.0.5 ", I am following the steps outlined here to add an external DB server to the WHM.

To create a MySQL super user, you must enable the Super privilege in the Privileges section of the phpMyAdmin interface (cPanel >> Home >> SQL Services >> phpMyAdmin).

(RDS) does not allow you to enable the Super privilege. " At this point RDS provides master user and doesn't provide a SUPER-USER. As a result I can't add the RDS as an external Database, any ideas about how to solve this issue? At the same time, I tried adding the same RDS to a different web host control panel (not WHM) and it worked just fine, so I am wondering why it is not working on WHM and how to fix it? Thx.

• 

  oah

  • August 29, 2018 01:04

  Attached is a screenshot for the error that I am getting. 54209

  0
• 

  cPanelLauren

  • August 29, 2018 17:31

  Hi @oah Unfortunately you are not able to use RDS with WHM as a remote MySQL Profile. We do have a feature request open for this here: Support for AWS RDS as Remote MySQL Server I would encourage you to log in at the features site become a part of the conversation and vote for the issue! Thanks!

  0
• 

  oah

  • August 29, 2018 19:26

  Hi @oah Unfortunately you are not able to use RDS with WHM as a remote MySQL Profile. We do have a feature request open for this here:

  0
• 

  cPanelLauren

  • August 29, 2018 19:46

  You're very welcome I hope to see it get addressed soon! Thanks!

  0
• 

  oah

  • August 29, 2018 21:13

  @cPanelLauren I found that it is possible to add the any remote MySQL database server (including RDS to php my admin directly), i tested that on my machine and it worked just fine. How is that different from adding the RDS via the WHM, what I am going to lose in the scenario of adding the RDS to phpmyadmin directly, The codes below does the trick, all I have to do is to edit the file: config.inc.php in the phpmyadmin folder and add the following lines at the end of the file. I just tried it and it worked like charm. $i++; $cfg['Servers'>[$i]['host'> = 'url'; //provide hostname and port if other than default $cfg['Servers'>[$i]['user'> = 'Root'; //user name for your remote server $cfg['Servers'>[$i]['password'> = 'pass'; //password $cfg['Servers'>[$i]['auth_type'> = 'config'; // keep it as config

  0
• 

  cPanelLauren

  • August 30, 2018 17:43

  Hi @oah In this instance, you're bypassing WHM and I believe any configuration changes you'll need to make will need to be done manually - WHM won't be managing this. I also want to point out that the config file for phpmyadmin may be overwritten.

  0
• 

  oah

  • September 03, 2018 22:27

  Hi @oah In this instance, you're bypassing WHM and I believe any configuration changes you'll need to make will need to be done manually - WHM won't be managing this. I also want to point out that the config file for phpmyadmin may be overwritten.

  
  Aha, that makes it so clear. Thx a ton guys.

  0
• 

  cPanelLauren

  • September 04, 2018 12:01

  You're most welcome, I'm glad we could help! Thanks!

  0

Please sign in to leave a comment.