AWS Lightsail - Accessing a mysql database in a different account?

Question

I have 2 accounts (root user) set up. They are in the same region.  
  
One account (call it 'Account A') has a mysql database instance with multiple database schemas.  
  
The other account (call it 'Account B') has the webserver (we have an external developer building the web site which accesses the database schema).  
  
I have tried doing a simple mysql connection (using the mysql client on the ubuntu server) try and access Account A's database. However, I get an 'access denied'.  I have a feeling it may be because the database isn't open to the public.  Is there anyway to do this securely?  
  
Has anybody done this successfully?  
  
Many Thanks for any help!

dipens · Answer

Thank you for the detail.

David G · Answer

You would have to open the public ports for mysql.  
  
Each account has it's own VPC. All instances in that VPC can access each other using the VPC, but no other instances.  
  
I blogged about it here: https://www.geekyramblings.net/2019/03/22/lightsail-network-isolation/  
  
david

AWS Lightsail - Accessing a mysql database in a different account?

Relevant content