I am using DW 2021cc, I am using a WAMP server for my testing server on Windows 10 Pro, 64-bit operating system, x64-based processor.
I have a test.php file that checks for a connection to MySQL. Code:
<?php
$servername = "bench";
$username = "root";
$password = "";
$db_name = "benchesbricks";

// Create Connection
$conn = mysqli_connect($servername,$username,$password,$db_name);

//Check Connection
if(!$conn) {
die("benches_and_bricks Connection Failed : ". mysqli_connect_error());
}
echo "benches_and_bricks !! you have Connected Successfully !!!";

?>

when I run it, it tells me I have a connection.

When I try connecting using Database Connection 2 see image below





Any ideas would be appreciated

Dan

Something is not correctly setup in your testing and remote server - most probably wrong URL.