Title: How to Test MySQL Database Connectivity Using PHP  
PrimaryCategory: cPanel &amp; WHM Hosting  
Type: Procedural  
Tags: mysql, database, php, connectivity, test, script  
Source UI Terms: dbserver, dbuser, dbpassword, dbname  
Source Reference: How to Test MySQL Database Connectivity Using PHP  

---

### Procedural

Steps:  
1) Create a PHP script with the following code to test MySQL database connectivity:

```php

```

2) Replace the placeholder values in the script as follows:  
   - `dbserver`: For Linux Hosting (cPanel), use `localhost`; for Windows Hosting (Plesk), enter the MySQL Server IP address.  
   - `dbname`: Specify the complete database name including the prefix (e.g., `reseloaq_mysql`).  
   - `dbuser`: Provide the database user associated with the database.  
   - `dbpassword`: Provide the password for the specified database user.

Warnings:  
- The script uses deprecated PHP MySQL functions (`mysql_*`). For newer PHP versions, consider using MySQLi or PDO extensions for improved security and compatibility.

Summary:  
Use this PHP script by updating the database connection details to verify your website’s MySQL database connectivity and list tables in the specified database.

Evaluation Pairs:  
Q: How do I test if my website can connect to its MySQL database using PHP?  
A: Use a PHP script with the `mysql_connect` and `mysql_select_db` functions to connect and run a query such as `SHOW TABLES` to verify connectivity and list database tables.

Q: What value should I use for `dbserver` in the PHP script on Linux cPanel hosting?  
A: Use `localhost` as the value for `dbserver` on Linux Hosting with cPanel.

Q: What should I enter for `dbname` when testing MySQL connectivity?  
A: Enter the full database name including any prefix, such as `reseloaq_mysql`.

When you want to verify that your website can connect to its database. This article explains how to test MySQL connectivity using a PHP script.
 
Provided below is a simple PHP script to test MySQL database connectivity. The result of this script displays the names of the tables present within the specified database.
<h2 id="s-script">Sample Script</h2>
<pre style="white-space: pre-line;background: #F9F9FB;color: #434c5e;border-left: 2px solid #28bd8b;"> <code class="language-php">
 &lt;!--?
 $connect=mysql_connect(&quot;dbserver&quot;,&quot;dbuser&quot;,&quot;dbpassword&quot;) or die(&quot;Unable to Connect&quot;);
 mysql_select_db(&quot;dbname&quot;) or die(&quot;Could not open the db&quot;);
 $showtablequery=&quot;SHOW TABLES FROM dbname&quot;;
 $query_result=mysql_query($showtablequery);
 while($showtablerow = mysql_fetch_array($query_result))
 {
 echo $showtablerow[0].&quot; &quot;;
 } 
 ?--&gt;
 </code>
 </pre>
Explanation about the variables used in the script:
<ul><li>dbserver: Mention the value as localhost for Linux Hosting (cPanel). For Windows Hosting (Plesk), the MySQL Server IP needs to be mentioned. <img src="https://content.endurance.com/wholesale_brands/DB_Server_Conn_Plesk_MySQL.jpg" alt=""></img></li><li>dbname: Specify the complete database name, including the prefix. For example, reseloaq_mysql.</li><li>dbuser: Mention the database user associated with the database.</li><li>dbpassword: Mention the password for the above database user.</li></ul>

When you want to verify that your website can connect to its database. This article explains how to test MySQL connectivity using a PHP script.