Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View


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:

    $host = '';
    $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>';
        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!


Re: mysql_connect()

Andrew Clark wrote:
Quoted text here. Click to load it

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


Re: mysql_connect()

Quoted text here. Click to load it

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.

Re: mysql_connect()

Quoted text here. Click to load it

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


Re: mysql_connect()

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,

Site Timeline