I'm trying to connect to my AWS Lightsail database instance with Navicat Premium 15.0.21 (newest available version at the time of posting).
My database is in public mode. I copied and pasted the endpoint, username, and password straight into Navicat; Port 3306. Lightsail reports the database as "Available."
These settings have not changed for over 24 hours and I have rebooted the instance multiple times but Navicat keeps telling me "Access Denied"
Here's a screenshot of the error: image
I have also tried connecting with a VPN via multiple countries. And I have tried to connect with DBeaver; same issue (Access Denied). I'm running Navicat on MacOS Catalina 10.15.4.
Anyone know what's wrong?