I finally managed to install MySQL succesfully. I created a simple DB with
two
different tables. I also created a simple PHP script to list all DBs and
tables.
However, it seems that the PHP script cannot access MySQL server, because
the
following error message is displayed:
_____________
This means that your server is not up, most likely. Can you connect from
the command line? try running
ps -efc | grep mys
....do you see an entry for mysqld?
How did you start your server?
HTH
Jeff
____________
Warning: mysql_connect(): Can't connect to local MySQL server through
socket
'/var/lib/mysql/mysql.sock' (2) in /srv/www/htdocs/sqltest.php on line 4
Warning: mysql_list_dbs(): supplied argument is not a valid MySQL-Link
resource in /srv/www/htdocs/sqltest.php on line 5
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
resource in /srv/www/htdocs/sqltest.php on line 6
Any idea what might be wrong? There is no file 'mysql.sock' in '/var/lib/
mysql'. The PHP script is as follows:
<html><body>
<?php
$link_id = mysql_connect("localhost", "root");
$result = mysql_list_dbs($link_id);
$num_rows = mysql_num_rows($result);
while ($db_data = mysql_fetch_row($result)) {
echo $db_data[0]. "<BR>";
$result2 = mysql_list_tables($db_data[0]);
$num_rows2 = mysql_num_rows($result2);
while ($table_data = mysql_fetch_row($result2)) {
echo "--" . $table_data[0]. "<BR>";
}
echo "==> $num_rows2 table(s) in " . $db_data[0] . "<BR>";
}
?>
</body></html>
Regards Sami
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]