We've checked with the host they responded...
"With regards to the host for the database, your server is the host so this is either localhost, 233382.vps-10.com or the IP address.
Checking this for you, the user has access to the database from the command line and creating a simple test script:
This is the connection script they've used on test.php
// Create connection
// Check connection
echo "Failed to connect to MySQL: " . mysqli_connect_error();
The difference appears to be in using "localhost" instead of the IP address, but when I try that in Dreamweaver the Define section tests successfully but when I try to open a recordset I get the same error. The website too displays the same error.
<sigh> I could understand if we'd changed something, but we didn't. This was all working fine, which you can confirm too because you've been assisting us with the site.
Why would this just stop?
I would appreciate your advice as I have no technical knowledge of MySQL at all.
I'm also, obviously, still chasing the host but their test connection works so they're pretty much saying that everything is fine.
Is this a Dreamweaver problem then?