RDS Connection String in PHP

Question

I'm frantically beginning the move from Xeround to Amazon RDS. I've been unable to connect to RDS via PHP. I've tried a number of variations of the following:

$connection = @mysql_connect('host:port','uname','password')

Nothing seems to go through. I'm using the same port value as I had used previously with Xeround, so that's not the issue. I'm certain the host is the endpoint and the username and password are correct. I've tried using the same parameters in C# and the MySQL workbench, but to no avail. What should I do to troubleshoot this problem?

Thanks!

what error did you get? Have you tried with `mysql_error()` to know the exact error? — Yogesh Suthar, May 02 '13 at 04:48
Have you tried using the default port, instead of specifying `:port`? I've used RDS from PHP and never needed to specify the port. — Barmar, May 02 '13 at 05:04
Are your security groups set up correctly? Good luck with the frantic migration :( — clieu, May 03 '13 at 03:40

score 0 · Answer 1 · answered May 03 '13 at 04:27

0

I resolved the problem. I needed to edit the security group and add a CIDR exception for the current IP address. The connection string I initially posted was correct.

Thanks!

answered May 03 '13 at 04:27

user1120540

121
1
8

RDS Connection String in PHP

1 Answers1