Cannot access aws EC2 phpmyadmin mySQL

Question

I have setup phpmyadmin on EC2 ubuntu instance. Here is the link: http://ec2-54-191-119-142.us-west-2.compute.amazonaws.com/phpmyadmin

But I am not able to access it from my php file from my laptop.

<?php

$hostname = "ec2-54-191-119-142.us-west-2.compute.amazonaws.com:3306"; //database host server
$database = "fyp_data"; //database name
$username = "root"; //database user
$password = "*********"; //password

$con=mysql_connect($hostname,$username,$password);
if(! $con)
{
die('Connection Failed'.mysql_error());
}
else
echo "hurray!";
?>

Here is the error : "A connection attempt failed because the connected party did not properly respond after a period of time or established connection failed because connected host has failed to respond"

I have tried everything. Thanks in advance!

Answer 1

Make sure that port 3306 in your EC2 security group (inbound) is set to your home/office ip else the EC2 will just block your connection.

More info about how to setup the security group can be found here: http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/using-network-security.html#adding-security-group-rule