Error connecting to mysql server

[pourmeanother]

Using the following code I receive "Error" as the output -- meaning I'm not successfully connecting to the MySQL server.

 

PHP4

mysql server version 4.1.14

phpMyAdmin 2.11.9

MySQL client version 3.23.49

(Not sure which of the above is required information)

 

    <?php
    $host="localhost";
    $user="user";
    $password=" ";
    $database="databasename";

    $cxn = mysql_connect($host, $user, $password);
    if(!$cxn)
    {
         exit("Error");
    }
    $db_selected = mysql_select_db($database);
    if(!$db_selected)
    {
         exit("Could not connect");
    }

    $query = "SELECT * FROM AdamsChristen";
    $result = mysql_query($query, $cxn);
    if(!$result)
    {
       exit("Data currently unavailable");
    }

    while( $row = mysql_fetch_assoc($result) )
    {
       extract($row);
       echo "<table cellspacing='15'>";
       echo "<tr><td colspan='5'><hr></td></tr>\n";
       echo "<tr>
             <td>$semester$year</td>
             <td><b>Helpfulness:</b>\n$helpfulness</td>
             <td><b>Ease of Grading:</b>\n$grading</td>
             <td><b>Attention Factor:</b>\n$interesting</td>
             <td><b>Attendance Mandatory:</b>\n$attendance</td>
             <td><b>Comments:</b>\n$comments</td>
             </tr>\n";
       echo "<tr><td colspan='5'><hr></td></tr>\n";
    }

    echo "</table>";

    mysql_close($cxn);
    ?>

 

Trying to troubleshoot. All help is appreciated!

[Alt_F4]

 

    <?php
    $host="localhost";
    $user="user";
    $password=" ";
    $database="databasename";
    ?>

 

are you sure that your password is " " and not ""??

[pourmeanother]

Thanks for the prompt reply. Tried changing that, same output.  ???

[MasterACE14]

change this.

    $cxn = mysql_connect($host, $user, $password);
    if(!$cxn)
    {
         exit("Error");
    }

 

to this...

    $cxn = mysql_connect($host, $user, $password) or die(mysql_error());

 

see what you get then

[pourmeanother]

"Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46)"

 

Which I'm assuming has something to do with my setup (or lack of)? Not sure how to resolve that...

[Fruct0se]

try editing your settings.php and changing 'localhost' to whatever your hostname is..e.g. 'mysql.mysite.com'

[pourmeanother]

I did a little more digging, and found that I needed to replace 'localhost' with 'mysql'. Upon doing that, the output was exactly as desired.

 

Thanks for the help, I may be back just yet