AWS RDS – SQLSTATE[HY000] [1130] Host ‘ec2-ip’ is not allowed to connect to this MySQL server
My Laravel(hosted on EC2) app database(Mysql) is hosted in AWS RDS it was working fine but now it gives the error “SQLSTATE[HY000] [1130] Host ‘172...***’ is not allowed to connect to this MySQL server, for every API call.
I can’t connect db to run any SQL query (like SHOW GRANTS) and try to change the security inbound.
Some suggest to run run this
How to put MySQL project online using AWS
What is the correct way to do it in the free tier? I have a project done using Node and MySQL, it is on my localhost. I made a RDS and i conected the DB by it, but unfortunally i couldnt afford to pay the public key directly on the RDS. So i saw that another way to do it it’s by the conection between VPC, EC2 and RDS. But i watched tens of tutorials, inclding AWS’s channel on youtube, creating VPCs, EC2 instances, RDS instances, adding the IP of the EC2 in the Inbound rules, trying to conect with MySQL Workbench by SSH… I could even conect the RDS with the EC2, installing MySQL on the virtual PC, but i couldnt make it work in general. I dont have idea how to put my MySQL project online using AWS and make a good connection. Everytime i try to conect in Workbench it gives me a error of timeout