PHP MySQL external database connection timed out

Question

I'm getting a connection timed out when I try to connect to an external (not on the same server as this code is on) database through the following code. I know the settings of the database is set up right, and the login info is good, 'cause I can login fine from my computer with HeidiSQL. If anyone can see a problem with this code, thanks.

function database_connect(){
$link = @mysql_connect("xx.xxx.xxx.xx:3306","root","pass"); 
$sql_error = mysql_error();

if (!$link) { 
    echo "Connection with the database couldn't be made.<br>";
    echo "$sql_error"; 
    exit;
}

if (!@mysql_select_db("databasename")) {
    echo "The database couldn't be selected.";
    exit;
}
return $link;
}
database_connect();

Can you ping the MySQL server from your PHP server? Or connect with the command-line mysql program? — Brendan Long
– Brendan Long, Commented Oct 11, 2012 at 20:12
Who is issuing the "connection timed out"? PHP? Your browser? — Pekka
– Pekka, Commented Oct 11, 2012 at 20:12
general tip: don't allow remote root access to the DB server. that's just begging for a world of hurt. always use limited-rights accounts. — Marc B
– Marc B, Commented Oct 11, 2012 at 20:26
What error are you getting exactly, can you quote it? If the connection is timing out on your server but not on your local PC, the problem might be with your server — Pekka
– Pekka, Commented Oct 11, 2012 at 20:28

user1732887 · Accepted Answer · 2012-10-11 20:47:36Z

1

have you tried adding the IP address of where that script is hosted to "Remote Database Access Hosts"? If you're on cPanel, you need to allow the IP address who can remotely access the datase(mysql). If you're not, then this is just an idea of what to do.

answered Oct 11, 2012 at 20:47

user1732887

2981 gold badge2 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Deniz Zoeteman · Accepted Answer · 2012-10-11 21:23:46Z

1

Problem known now.

My webhost does not allow connections to an external database.

answered Oct 11, 2012 at 21:23

Deniz Zoeteman

10.2k26 gold badges74 silver badges98 bronze badges

Collectives™ on Stack Overflow

PHP MySQL external database connection timed out

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related