Script for a quick PHP MySQL DB connection test.

db-connect-test.php

<?php
# $ php -f db-connect-test.php
# a quick and easy script for db connectivity

$dbname = 'name';   // DB name
$dbuser = 'user';   // user name
$dbpass = 'pass';   // password
$dbhost = 'host';   // host

$connect = mysql_connect($dbhost, $dbuser, $dbpass) or die("Unable to Connect to '$dbhost'");
mysql_select_db($dbname) or die("Could not open the db '$dbname'");