1

Facing some issue regarding the connectivity of PHP/Laravel application from host machine EC2 to managed AWS RDS Mariadb instance.

When connecting from Laravel app though .env (db settings) it return this error

SQLSTATE[HY000] [2002] Permission denied (SQL: select * from `users` where `id` = 1234567 limit 1)

Some flows already check and it passes successfully.

  • Telnet is successful from ec2 host machine to AWS RDS instance
  • From Host Machine EC2 mysql -h your-db-instance.x12345abcde.region.rds.amazonaws.com -u your_username
  • P 3307 - It successfully connected and execute the corresponding queries.
  • .env file permission already check have enough permission at file level..
Improve this question
1
  • your connection username your_username doesn't have select grant on users? If you execute show grants as this user what does it show? Commented Feb 2 at 21:52
Related questions
2051
How do I get PHP errors to display?
2
Laravel cannot connect to MySQL in Amazon RDS, but can connect from command line
2
SQLSTATE[HY000] [1045] Access denied for user 'db_user'@'ip_address' (using password: YES) trying to connect from elastic beanstalk ec2 to RDS
Load 6 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.