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.



Share this page:


Was this article useful? Have any suggestions or improvements to the information?

Also Read

HTTP Authentication error in PHP

Issues with HTTP Authentication error in PHP. Variables $_SERVER['PHP_AUTH_USER'] and...

What is the proper MariaDB - MySQL import and export format?

The easiest way to import and export a database is via the backup section of our hosting control...

How do I import into a MariaDB - MySQL database?

Log into your control panel and go into the MariaDB - MySQL section. Make sure you have an...

Changing Maximum Upload Size

Firts check your control panel for the "PHP Options" icon. If available you can change the PHP...

Could not connect to the MariaDB - MySQL database

You will want to verify you are using the correct database name, username and password. All...