Hi,

Using linux redhat 6.2, apache1.3.20 (compiled fresh), php4.0.5 (compiled
fresh with msql support), mysql 3.23.38 (rpm install for server and
client).

I run the following php4 test  script in query.php from a browser:

snip--
<?php
 $hostname="localhost";
 $username="XXXX";
 $password="****";
 $databasename= "midisland;
 $tablename = "list";
?>

<?php
mysql_connect($hostname, $username, $password);
$db_table = mysql_list_dbs();

?>
snip--

I get the following errors when I view the souce in my browser

<br>
<b>Warning</b>:  MySQL Connection Failed: Can't connect to local MySQL
server through socket '/tmp/mysql.sock' (111)
 in <b>/home/httpd/html/query.php</b> on line <b>21</b><br>
<br>
<b>Warning</b>:  MySQL Connection Failed: Can't connect to local MySQL
server through socket '/tmp/mysql.sock' (111)
 in <b>/home/httpd/html/query.php</b> on line <b>22</b><br>
<br>
<b>Warning</b>:  MySQL:  A link to the server could not be established in
<b>/home/httpd/html/query.php</b> on line <b>22</b><br>
<br>
<b>Warning</b>:  Supplied argument is not a valid MySQL result resource in
<b>/home/httpd/html/query.php</b> on line <b>23</b><br>

mysql.sock is in /var/lib/mysql  and not /tmp/mysql.sock.

Can someone give me an idea as to what's wrong?

Thanks,


Frank


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to