Hi,

I am trying to install a script on my server and the software company has provided me with a simple php script to make sure mysql is working on the server. If it is working the script will output "mysql_ok" and I am getting errors so that means I have not plugged in the right mysql info. The script is really simple and is only a few lines and all I have to do is fill out the first couple lines with the mysql information. Please let me know exactly what should be filled in these first few lines so I can get this to work. If possible can you fill out the information and make sure it displays "mysql_ok"

Here is the simple script that was provided:

<?php
/* Please enter your database info below */
$database='database';
$user='user';
$password='password';
$host='localhost';

/* DO NOT EDIT FURTHER !!! */

$dbh=mysql_pconnect($host,$user,$password);
mysql_select_db($database);
mysql_query("create table mysql_ok ( b bigint )");
$q=mysql_query("show tables");
while(list($table)=mysql_fetch_row($q)) {
echo "$table<br>";
}
?>