You can test MySQL connection by creating a testmysqlconnection.php file (recommended to identify the content of the file) or any desired file name and access it with your website. Kindly follow the instructions below:
Step 1: Open a notepad or any note editor from your computer.
Step 2: Add the following script.
<?php
$connection= mysql_connect(‘hostname’,’dbuser’,’dbpassword’);
if (!$connection) {
die(‘Could not connect to MySQL: ‘ . mysql_error());
} else {
echo ‘Connection OK’;
}
mysql_close($connection); ?>
Step 3: Save the file as testmysqlconnection.php or any desired file name, upload it to your webspace and ensure it is in the right directory.
Step 4: Access your website (depends on what directory the domain name is pointed to). Example https://yourdomain.com/testmysqlconnection.php