New to AWS, and I am attempting to connect an API on my EC2 instance with my RDS. Attempts return a 500 Error
What I am able to do successfully:
Connect to the RDS with an API hosted on an external server. Run API's on my EC2 instance, just not ones that connect to database.
What solutions I have attempted: Added new MYSQL/Aurora Inbound and Outbound rules to include: EC2 Private IPv4 Address/32 EC2 Public IPv4/32 EC2 Security Group
Because I can reach the database externally and run PHP scripts on the server, I am leading that the issue is with the EC2 Connecting with the RDS though I am sure it could be something else.
*I am using PHP APIs to connect to MySQL RDS
Thank you for your time and assistance.
mysql
client to connect to your db? It also does not work, or the issue is your API call? – Marcin