Posted by courtney.machi on 10/05/60 11:48

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...

• Next in forum: Re: Can somebody help me to write PHP function ? - Just in Time alghoritm.
• Prev in forum: Re: Can somebody help me to write PHP function ? - Just in Time alghoritm.
• Thread view: Please Help! Can't connect to remote MySQL server using PHP

[Reply to this message]