Allow Appsheet Access to MySQL on Amazon VPC?
Hi There. The MySQL on my local NAS died so Iโm desperately trying to setup an instance in Amazonโs RDS. Iโve got the database set up there but run into a roadblock allowing AppSheet access to it. I put in my user credentials (Iโve tested they all work with MySQL workbench) but AppSheet canโt connect.
OK so I googled and found an instruction from AppSheet on how to connect to an Amazon RDS โUsing MySQL on Amazon RDSโ but it describes setting up a Security Group which seems to be a legacy system no longer supported. It seems to have been dropped and new users now use VPCs. I canโt find any instructions on how to allow access through the VPC. I have searched through here and canโt seem to find anything either. Can someone give guidance please.
OK I got it working. Not sure the exact step which fixed it but it works now. If I can work out which step fixed it Iโll post here.
For completeness Iโll post here what I did: In the Amazon Web Services console select RDS service (under Database).
Select Instances on the left panel
Select your instance
Scroll down to the Details section and under the heading โSecurity groupsโ click on the link with โwizardโ mid string.
On the resulting window select the security group in the top list and โInboundโ tab in the bottom section then hit the Edit button to add an entry. Done!
User | Count |
---|---|
42 | |
34 | |
26 | |
23 | |
15 |