Test MySQL Connection

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.


  • 117 Users Found This Useful

Was this answer helpful?

Related Articles

What is the path to PHP5?

We are currently running the latest stable version of PHP5. /usr/bin/php

How do I add a user to a MariaDB & MySQL database?

In the MariaDB / MySQL Database section of your hosting control panel, after creating a database...

How do I backup a MariaDB - MySQL Database?

In the control panel, within Backup section, under Download a SQL Database Backup will be your...

How do I change my PHP settings?

How do I change my PHP / PHP.INI settings?To change your PHP settings, just login to your hosting...

Premature end of script headers

If you receive an Internal Server Error 500 and checking your log files displays "Premature end...