- Newest
- Most votes
- Most comments
Hi @silvawebdevelopment, hope you are doing well.
as far as I can see you light sail instance can connect to the database, that's great, however the problem is access deny on the database authentication.
To troubleshoot this problem do the following steps
- Check the password is the right one, a common mistake is to copy the password and include a non-visible character.
- if you are using a user different than the database administrator, check if has the right permissions to connect to the Database, especially if there are any IP limitations, another common access denial is related to users associated with the IP address.
- Review the database configuration following this document
hope that helps and let you find the issue
I was able to connect on my other computer (which I no longer have access to) and now on this new machine I cannot connect, the connection process is exact, using a vs code extension I can visualize the database, but on my new computer using the same data that I use there in the vs code extension I can't connect, is there a place where I can see the list of allowed ips?
I managed to connect to my database through the terminal but I still can't connect using a tool like mysql workbench
Hi,
It sounds like you haven't configured the database credentials correctly. Please refer to this document to see if it helps resolving your issue: https://lightsail.aws.amazon.com/ls/docs/en_us/articles/amazon-lightsail-connecting-to-your-mysql-database
Thanks.
Relevant content
- asked 2 years ago
- AWS OFFICIALUpdated 10 days ago
- AWS OFFICIALUpdated 10 months ago
- AWS OFFICIALUpdated 24 days ago
- AWS OFFICIALUpdated a year ago