AWS RBMS Connection with a user account.

hmaddy

Well-Known Member
May 6, 2020
382
39
28
Chennai
cPanel Access Level
Root Administrator
In a shared Server one account need to connect with aws database. How to configure this.??? we can connect data base locally with workbench or any other client software. But cant connect with shared server. Connection timed out error
 

cPJustinD

Administrator
Staff member
Jan 12, 2021
286
52
103
Houston
cPanel Access Level
Root Administrator
Hello anoopk350! Have you already added the IP of the AWS database's server in cPanel >> Databases >> Remote MySQL. If not, that may explain why you're unable to connect. We've published an article with more information on this here:

Why am I unable to connect to a MySQL database remotely?

I hope that this helps! If you have any additional questions or concerns, please let us know!
 

quietFinn

Well-Known Member
Feb 4, 2006
2,024
542
493
Finland
cPanel Access Level
Root Administrator
Is MySQL port 3306 out open in the shared server, and is MySQL port in open and is MySQL listening on the server IP in the database server?
 

cPJustinD

Administrator
Staff member
Jan 12, 2021
286
52
103
Houston
cPanel Access Level
Root Administrator
Thank you for that clarification. As there is a timeout occurring, it sounds like the issue may be related to the server's local or network firewall. Could you provide the output of the following commands, please?

lsof -iTCP:3306 -sTCP:LISTEN

curl portquiz.net:3306 | grep test

We look forward to hearing back from you!
 

hmaddy

Well-Known Member
May 6, 2020
382
39
28
Chennai
cPanel Access Level
Root Administrator
AWS postgre database is using. already add the port 5432 to csf and remote mysql option in cpanel. But still its not connecting.
 

cPJustinD

Administrator
Staff member
Jan 12, 2021
286
52
103
Houston
cPanel Access Level
Root Administrator
Thanks for that information anoopk350. I think it would be best to open a support ticket so that our analysts can review the issue more thoroughly and determine what exactly is occurring. You can submit a support request using the "Submit a ticket" link in my signature below.

Please be sure to link this thread when opening the ticket and provide the ticket number here so we can track the issue appropriately. If possible, please post the resolution on this thread as it may help other community members with similar issues.