Unable to connect to aws RDS from WHM

arunnair555

• June 30, 2017 19:13

Hello guys, I am facing an issue with connecting AWS RDS to WHM. As per my knowledge I have done all the things correctly. But getting the permission error. Now I have the doubt that whether is it possible to connect the RDS to WHM. Thank you for anticipating for a reply.

• 

  SysSachin

  • July 01, 2017 03:54

  Hello, The error message is showing that mysql privileges is not set for the user gauravdb. You have to set privileges through cpanel.

  0
• 

  arunnair555

  • July 01, 2017 13:36

  Hi SysSachin, Thanks for the reply. But the issue is not related to permission. While checking on a deeper level it is found that you need a user with Super privilege to connect from WHM to RDS. There is only one such user in the RDS ie 'rdsadmin'; which is used for taking backups and snapshots. I tried to give the Super Privilege to a root user but ended with the error: ERROR 1054 (42S22): Unknown column 'ERROR (RDS): SUPER PRIVILEGE CANNOT BE GRANTED OR MAINTAINED' in 'field list'. AWS will not allow any other user to have Super Privilege. Did you faced this issue? I have no clue on how to do Thanks&Regards, Arun Nair

  0
• 

  Anoop P Alias

  • July 02, 2017 04:35

  Yes cPanel will need a superuser to connect and activate the remote MySQL profile. You should look at other providers like Google/Rackspace for managed cloud DB service. I am not sure if they provide superuser access though.

  0
• 

  arunnair555

  • July 02, 2017 06:19

  Thanks for the reply Anoop; Wasted few days :(

  0
• 

  cPanelMichael

  • July 03, 2017 15:08

  Hello, The earlier post is correct. Here's the notes from our (RDS) does not allow you to enable the Super privilege.
  Thank you.

  0

Please sign in to leave a comment.