SQL Connect Ip

[Cooper94]

I'm trying to connect to an ip to get sql information the code is below. Any help would be fantastic thank you!

 

<?php
$database = "test";
$hostname = "69.113.255.195";
$port = "3306";
$username = "root";
$password = '147171';
?>

[premiso]

mysql_connect

 

$database = "test";
$hostname = "69.113.255.195";
$port = "3306";
$username = "root";
$password = '147171';
$con = mysql_connect($hostname . ":" . $port, $username, $password);

if (is_resource($con)) {
    mysql_select_db($database, $con) or die("Unable to connect to database");
}else {
    echo "Unable to connect to DB";
}

echo "Mysql connected just fine!";

[Cooper94]

The error came up as:

 

Warning: mysql_connect() [function.mysql-connect]: Host '78.129.167.15' is not allowed to connect to this MySQL server in /home/republi1/public_html/medievalages/med/db.php on line 7

Unable to connect to DBMysql connected just fine!

[premiso]

Your database is not setup to receive remote connections. Google how to setup your SQL server to receive remote connections. You will also have to forward ports.

 

If you intend to go this route, I would highly suggest changing the root password and creating a new account that only has access to that one table. You have some reading/googling to do now.

[Cooper94]

Is there anyway you can help me in this process, I have checked google and it was unsuccessful. I am using XAMPP which includes Apache and MySql. I have opened the ports 3306 and 80. Is there something I am missing?

 

Thank You

[Cooper94]

Anyone?

[PFMaBiSmAd]

Is the remote mysql server under your administrative control so that you can change its' settings?