I’m having problems connecting to a mysql database from a remote host. I’m working on switching site from Verio to DreamHost. To make a smooth transition, I’ve recreated the database on DreamHost, and am trying to connect to it from the Verio servers, but keep getting “DB Error: connect failed”
Here’s the connect code (not showing the real username & password, of course):
$db = DB::connect(“mysql://username:firstname.lastname@example.org/mariska”);
I’ve made sure that connections are allowed from the Verio servers. I’ve also verified that I can make the connection from my home machine (using CocoaMySQL).
Any thoughts? Info and advice would be greatly appreciated!