Test MySQL Connection

Knowledgebase

The following is a great way to verify a MySQL / MariaDB database connection issue. Create a file with with the name ultra-db-connect-test.php and populate it with the following information being sure to update the top four variables to your environment and run :


<?php
 $dbname = 'name';
 $dbuser = 'user';
 $dbpass = 'pass';
 $dbhost = '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'");
 $test_query = "SHOW TABLES FROM $dbname";
 $result = mysql_query($test_query);
 $tblCnt = 0;
 while($tbl = mysql_fetch_array($result)) {
   $tblCnt++;
   #echo $tbl[0]."<br ?---->\n";
 }
 if (!$tblCnt) {
   echo "No Tables Found<br />\n";
 } else {
   echo "There Are $tblCnt Tables<br />\n";
 }

For additional information regarding PHP and modules on the server create a file with the name ultra-php-info.php and populate it with the following information :

<?php
 
 // Show all information, defaults to INFO_ALL
 phpinfo();
 
 // Show just the module information.
 // phpinfo(8) yields identical results.
 phpinfo(INFO_MODULES);
 
 ?>

Sometimes you may need a different version of PHP, to switch PHP version log into your hosting control panel and click Select PHP Version.