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.

 

  • 121 Users Found This Useful

Was this answer helpful?

Related Articles

Increase PHP Memory

Fatal error: Allowed memory size of xxxxxxxxx bytes exhausted (tried to allocate xxxxxxxx bytes)....

How to Disable XCache for a Domain

On many of our servers xcache is use as part of the php caching mechanism. If you are...

How can I view/modify data in my MySQL database?

There are two ways to view your MySQL database with Ultra Web Hosting: Using phpMyAdmin Go...

When trying to connect to MariaDB or MySQL you receive error 2003 Cannot connect to MySQL on xxxxxx on port 3306 10060

The error 2003 "Cannot connect to MySQL on xxxxxx on port 3306 10060" means that the MySQL...

How do I backup a MariaDB - MySQL Database?

Here are the steps on how to backup a MySQL database using phpMyAdmin in your Ultra Web Hosting...