Unable to connect to aws RDS from WHM

arunnair555

Member
Feb 8, 2017
13
1
3
Trivandrum
cPanel Access Level
Website Owner
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.
 

Attachments

SysSachin

Well-Known Member
Aug 23, 2015
604
49
28
India
cPanel Access Level
Root Administrator
Twitter
Hello,

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

arunnair555

Member
Feb 8, 2017
13
1
3
Trivandrum
cPanel Access Level
Website Owner
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
 

Anoop P Alias

Well-Known Member
Mar 31, 2015
103
16
18
Kochi,Kerala,India
cPanel Access Level
Root Administrator
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,884
2,254
463
Hello,

The earlier post is correct. Here's the notes from our Manage MySQL Profiles document:

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

Amazon Relational Database Service (RDS) does not allow you to enable the Super privilege.
Thank you.