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.

If MySQL is giving you trouble, Ultra Web Hosting will be able to help you identify and resolve the issue. Click here to contact our support department.

 

  • 117 Users Found This Useful

Was this answer helpful?

Related Articles

403 Forbidden error with Drupal after install

There are a few things you can do to fix the 403 Forbidden error with Drupal after install:...

What is the path to PHP?

The path to PHP on Ultra Web Hosting is /usr/bin/php.  Ultra runs many different versions of PHP...

InnoDB Error Attempted to open a previously opened tablespace

When receiving the error... "InnoDB: Error: Attempted to open a previously opened tablespace....

Changing your PHP version

Have you received an error regarding your PHP version? If so, you may quickly and easily change...

Strict Standards: Non-static method JLoader::register() should not be called statically in

The error message...  Strict Standards: Non-static method JLoader::register() should not be...