Currently, I have set up two servers on Amazon AWS. One server is dedicated to running PHP while the other handles MySQL. Accessing the MySQL database through my terminal and MySQL Query Browser has proven successful.
However, I am facing challenges in establishing a connection between the PHP and MySQL servers.
The following PHP code represents my attempts so far (which only work for "localhost" databases).
$dbbase = 'mydb';
$dbuser = 'myuser'; // Your MySQL username
$dbpass = 'mypassword'; // ...and password
$dbhost = 'localhost:3306'; // Internal IP for MYSQL Server
// connect to database
$dblink = mysql_connect($dbhost, $dbuser, $dbpass)
or die ("System Down");
mysql_select_db($dbbase, $dblink)
or die ("Database Down");
I believe that I should be able to reroute this code through internal AWS traffic, but I am open to any solution that works at this point. This will serve as my starting point.
This is what I have already attempted:
Included the IP of the PHP server in the Security Group for MySQL(3306) permissions
Attempted to use the internal, external, and private IPs/DNSs of the MySQL Server as the $dbhost variable
Created a wildcard entry (myuser@%) on the MySQL server
If you have any ideas or tips, they would be greatly appreciated.