Test connection to the database (mysql, pgsql etc) generalist script

db_connection_test_example.php

<?php

// change credentials below and then run this php script from terminal

$driver = 'mysql';
$host = 'localhost';
$port = 3306;
$dbname = 'test';
$user = 'root';
$password = '';

try {
    $conn = new PDO("$driver:host=$host;port=$port;dbname=$dbname", $user, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
	
    if ($conn) {
        echo "Connected Succesfully!\n";
    }
	
} catch (PDOException $e) {
    echo 'ERROR: ' . $e->getMessage();
}