Styjun

Ethiopian Airlines tickets seem to always have the same price regardless of the proximity of the date?

What is the simplest instruction set that has a C++/C compiler to write an emulator for?

Redirection operator, standard input and command parameters

Why would word of Princess Leia's capture generate sympathy for the Rebellion in the Senate?

What does Windows' "Tuning up Application Start" do?

why neutral does not shock. how can a neutral be neutral in ac current?

Will a ThunderBolt 3 (USB-C?) to ThunderBolt 2 cable allow me to use a MacBook Pro as second monitor?

Should I work for free if client's requirement changed

BIP-23 criticism: Is bitcoin PoW actually sha256+merkleGeneration? Or have I misunderstood coinbase/append?

Is it possible to have a career in SciComp without contributing to arms research?

Book about an amphibian race at the centre of the Earth

What's a German word for »Sandbagger«?

Found old paper shares of Motorola Inc that has since been broken up

Host telling me to cancel my booking in exchange for a discount?

Why is this guy handcuffed censored?

Manager is asking me to eat breakfast from now on

Why does airflow separate from the wing during stall?

How does the Gameboy's memory bank switching work?

You have no, but can try for yes

Counting multiples of 3 up to a given number

Do Indians need a separate Hong Kong visa if we already have a Chinese visa?

Weight functions in graph algorithms

Does unblocking power bar outlets through short extension cords increase fire risk?

Why does a tetrahedral molecule like methane have a dipole moment of zero?

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

Can I mix MySQL APIs in PHP?Connect to MySQL on AWS from local machineHow to safely upgrade an Amazon EC2 instance from t1.micro to large?1130 Host 'amazon-ec2-ip' is not allowed to connect to this MySQL serverupgraded Amazon EC2 instance and phpmyadmin cannot connect to mysqlAmazon EC2 Instance connectivityCannot connect remotely to EC2 MySQL installationConnecting with PuTTY to Amazon EC2 Windows instance running freeSSHdPHP mySQLi connection to AWS RDS in AWS EC2 InstancephpMyAdmin Remote AccessPHP connecting to AWS EC2 errorUnable to login into phpmyadmin

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

1

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

php mysql mysqli amazon-ec2

share|improve this question

edited Mar 29 at 4:42

mujuonly

asked Mar 26 at 12:01

mujuonlymujuonly

3,08911 gold badge1717 silver badges3838 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  By localhost, do you actually mean you are trying to connect from your local PC to the Amazon cloud
  
  – RiggsFolly
  Mar 26 at 12:09
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @RiggsFolly Yes exactly
  
  – mujuonly
  Mar 26 at 12:12
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Are you sure that your ec2 port 3306 is open to public?
  
  – Alex
  Mar 26 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 at 12:18
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  Make your question about exactly that.
  
  – deceze♦
  Mar 26 at 12:23
  

  
  
  
  

 | 
show 5 more comments

1

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

php mysql mysqli amazon-ec2

share|improve this question

edited Mar 29 at 4:42

mujuonly

asked Mar 26 at 12:01

mujuonlymujuonly

3,08911 gold badge1717 silver badges3838 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  By localhost, do you actually mean you are trying to connect from your local PC to the Amazon cloud
  
  – RiggsFolly
  Mar 26 at 12:09
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @RiggsFolly Yes exactly
  
  – mujuonly
  Mar 26 at 12:12
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Are you sure that your ec2 port 3306 is open to public?
  
  – Alex
  Mar 26 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 at 12:18
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  Make your question about exactly that.
  
  – deceze♦
  Mar 26 at 12:23
  

  
  
  
  

 | 
show 5 more comments

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

php mysql mysqli amazon-ec2

share|improve this question

edited Mar 29 at 4:42

mujuonly

asked Mar 26 at 12:01

mujuonlymujuonly

3,08911 gold badge1717 silver badges3838 bronze badges

$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;

share|improve this question

edited Mar 29 at 4:42

mujuonly

asked Mar 26 at 12:01

mujuonlymujuonly

3,08911 gold badge1717 silver badges3838 bronze badges

share|improve this question

edited Mar 29 at 4:42

mujuonly

asked Mar 26 at 12:01

mujuonlymujuonly

3,08911 gold badge1717 silver badges3838 bronze badges

asked Mar 26 at 12:01

mujuonlymujuonly

3,08911 gold badge1717 silver badges3838 bronze badges

asked Mar 26 at 12:01

mujuonlymujuonly

3,08911 gold badge1717 silver badges3838 bronze badges