1

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?

kryz
  • 13
  • 2
  • Based on the error message it looks like you can connect fine, and that the problem is user / password. – Tim Sep 20 '20 at 08:07
  • @Tim Interesting. Unfortunately I have also tried changing the password, still no login luck. And dbmasteruser is just the default username it gives you when you create the instance – kryz Sep 20 '20 at 08:47

1 Answers1

3

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.