Home / server / Questions / 1034597
Accepted
kryz
Asked: 2020-09-20 17:22:02 +0800 CST

"Access Denied" when trying to access AWS Lightsail database

  • 772

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?

database database-administration amazon-web-services amazon-lightsail navicat

1 Answers

  1. Best Answer

    I had the same problem when setting up the connection in MySQL Workbench.

    The cause was the following: When you double click to copy the password from the AWS page, it appends an enter at the end. This is copied into the password field as well. So the password is not correct.

    Copy the password by selecting it character by character. Then there will be no enter at the end and the connection will be correct.

    • 3