mysql_connect()

Hello,

I am having trouble connecting to my server with mysql_connect(). I can
connect via the command line on the server and with phpMyAdmin over our
network, but not though mysql_connect(). This is my script:

<?php
$host = '192.168.100.5';
$user = 'root';
$pass = <password>;

echo '<P>Connecting...</P>';
//echo 'mysql_connect('.$host.', '.$user.', '.$pass.');';
//$link = false;
$link = mysql_connect($host, $user, $pass) or die(mysql_error());

if ($link)
{
echo '<P>Connection OK!</P>';
mysql_close($link);
}
else
{
echo '<P>Connection failed.</P>';
}
?>


The last thing I see on the page when I load this is "Connecting..." -
nothing else. It's been a while since I have worked with PHP/MySQL so
please bear with me!

Thanks,
Andrew

Andrew Clark wrote:[color=blue]
> Hello,
>
> I am having trouble connecting to my server with mysql_connect(). I can
> connect via the command line on the server and with phpMyAdmin over our
> network, but not though mysql_connect(). This is my script:
>
> <?php
> $host = '192.168.100.5';
> $user = 'root';
> $pass = <password>;
>
> echo '<P>Connecting...</P>';
> //echo 'mysql_connect('.$host.', '.$user.', '.$pass.');';
> //$link = false;
> $link = mysql_connect($host, $user, $pass) or die(mysql_error());
>
> if ($link)
> {
> echo '<P>Connection OK!</P>';
> mysql_close($link);
> }
> else
> {
> echo '<P>Connection failed.</P>';
> }
> ?>
>
>
> The last thing I see on the page when I load this is "Connecting..." -
> nothing else. It's been a while since I have worked with PHP/MySQL so
> please bear with me![/color]

Call echo mysql_error(); after every MySQL function call to find out
what the issue is.

--
Oli

Andrew Clark <nospam@nospam.com> wrote:[color=blue]
> I am having trouble connecting to my server with mysql_connect(). I can
> connect via the command line on the server and with phpMyAdmin over our
> network, but not though mysql_connect(). This is my script:[/color]

Both these methods connect to "localhost". Your script suggests remote
access, this will not work since in many cases networking is disabled by
default (Good Thing(tm)). So read the mysql documentation and make sure
it's accepting remote network connections.

Daniel Tryba <partmapsswen@invalid.tryba.nl> wrote in
news:42a70940$0$49819$c5fe704e@news6.xs4all.nl:
[color=blue]
>
> Both these methods connect to "localhost". Your script suggests remote
> access, this will not work since in many cases networking is disabled
> by default (Good Thing(tm)). So read the mysql documentation and make
> sure it's accepting remote network connections.
>[/color]

Well, since I am running this on my local machine, I changed it to
locahost anyway. That IP was my machine's IP. But anyway.

After I changed it to localhost it still is not connecting. Nothing is
being output to the page after the call to mysql_connect().

Andrew

I got it! Wow, not too smart, I am.

It seems I kind of forgot to enable the MySQL extension in php.ini...

Thanks to all,
Andrew