使用PHP连接EC2中的RDS

Question

I am new to AWS. I have one EC2 instance and one RDS instance. I have everything installed and ports opened on both of them. I could able connect to my EC2 instance with PuTTy and able to FTP with WinSCP and is all good. I could even be able to login to my RDS instance and check all my databases from my computer with mysql CLI. But my php pages in EC2 instance and not communicating with RDS instance. I don't know why? I even tried to connect from my ec2 instance normally using mysql command and I achieved that. But not through my php file.

Error that I am getting, when I am trying to connect is Access denied for user 'ec2-user'@'.ap-southeast-1.compute.internal' (using password: YES)

Have anyone faced this type of connectivity problem earlier, could any one help me to achieve this,

Addition: Hi, I observed that my EC2 instance is in location southeast-1a and my RDS in southeast-1b. But with my RDS I don't have any option to choose availability zone as I enabled Multi-AZ option. Hope if that helps a bit more.

Thanks, Murali.

Answer 1

Have you tried:

GRANT SELECT ON database.* TO 'ec2-user@'servername.ap-southeast-1.compte.internal' IDENTIFIED BY 'password';

you may need to add additional permissions based on what you decide to grant