PHP - mysqli connect from localhost(my local PC) to amazon EC2 hosted database

Asked Mar 26 '19 at 12:01

Active Mar 29 '19 at 04:42

Viewed 525 times

I have tried to connect to Amazon EC2 instance MySql from localhost.

Tried:

Granting privilege for user for remote connect
Made domain ping-able from outside.
Able to login through phpmyadmin with same credentials
Gone through lot of Stackoverflow answers.

$link = mysqli_connect('ec2-12-223-36-172.compute-1.amazonaws.com', 'myuser', 'xxxxxxxxxxx');
// mysqli_connect('domain', 'myuser', 'pasword', 'dbname', 3306);
if (!$link) {
    die('Could not connect');
}

echo 'Connected successfully';
exit;

Warning: mysqli_connect(): (HY000/2002): Connection refused

edited Mar 29 '19 at 04:42

asked Mar 26 '19 at 12:01

mujuonly

11,370
5
45
75

By `localhost`, do you actually mean you are trying to connect from your local PC to the Amazon cloud – RiggsFolly Mar 26 '19 at 12:09
@RiggsFolly Yes exactly – mujuonly Mar 26 '19 at 12:12
Are you sure that your ec2 port 3306 is open to public? – Alex Mar 26 '19 at 12:17
2

This would require your database on EC2 to be exposed to the public internet. 1) You'd need to set it up this way, and 2) this is a terrible idea security wise. You typically tunnel into your EC2 machine using SSH and connect to the database through the tunnel. – deceze Mar 26 '19 at 12:18
How can I connect from Google cloud to EC2 database then? @deceze – mujuonly Mar 26 '19 at 12:22
3

Make your question about exactly *that*. – deceze Mar 26 '19 at 12:23
@deceze Currently am trying to do what is on question - If it's possible, I will try it in cloud as well – mujuonly Mar 26 '19 at 12:24
Are you sure you set proper setting to connect from outside? like bind address on my.cnf and correct host on myuser account? – huhushow Mar 28 '19 at 13:07
@huhushow Yes, I tried adding bind-address as mentioned in some article – mujuonly Mar 28 '19 at 13:23
There is already solution please check this : https://stackoverflow.com/questions/8344057/connect-to-mysql-on-aws-from-local-machine – Mayank Dudakiya Mar 29 '19 at 04:47

PHP - mysqli connect from localhost(my local PC) to amazon EC2 hosted database

0 Answers0