Please Help! Can't connect to remote MySQL server using PHP

[courtney.machi]

Hello,

I am trying to connect to a remote mysql server through php. Here's the
code:

mysql_connect("my.hostname.edu", "username", "password") or die
(mysql_error());
mysql_select_db("db_name") or die ("unable to select
db".mysql_error());
$r1 = mysql_query('SELECT * FROM table') ;

Using the mysql prompt on the remote server, the mysql -h -u -p works
just fine with the parameters i've specified here. According to the
user table I have the proper permissions. I just can't figure out what
could be preventing the connection here, although I am no expert...can
anyone help?!

BTW, I am using PHP 4.4.1 and mysql 5.0.

Thanks in advance...

[Alan Little]

Carved in mystic runes upon the very living rock, the last words of
<co************@gmail.com> of comp.lang.php make plain:

I am trying to connect to a remote mysql server through php.

Using the mysql prompt on the remote server, the mysql -h -u -p works
just fine with the parameters i've specified here. According to the
user table I have the proper permissions.

1) What does mysql_error() say?

2) Is your database configured to allow remote connections?

--
Alan Little
Phorm PHP Form Processor
http://www.phorm.com/

[courtney.machi]

Hi,

My error (actually a warning):
Warning: mysql_connect(): Lost connection to MySQL server during query
in /cm/sums/data.php on line 23
Lost connection to MySQL server during query

I'm not sure if it is configured to allow remote connections...where
would I look to find out?

Thanks :-)

[Alan Little]

Carved in mystic runes upon the very living rock, the last words of
<co************@gmail.com> of comp.lang.php make plain:

My error (actually a warning):
Warning: mysql_connect(): Lost connection to MySQL server during query
in /cm/sums/data.php on line 23
Lost connection to MySQL server during query
That's weird. I've seen connections time out when I'm in the mysql
monitor, but not a script connection.
I'm not sure if it is configured to allow remote connections...where
would I look to find out?

I'm afraid I don't know. MySQL administration is voodoo to me. I just
know such a setting exists.

You might be better off asking in a MySQL group.

--
Alan Little
Phorm PHP Form Processor
http://www.phorm.com/

[courtney.machi]

Voodoo...quite an accurate comparison, hehe.
Thanks anyway, have a great day!