"Access Denied" when trying to access AWS Lightsail database
Solution 1:
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.