Connecting to MySQL database on Earthlink
I have a client that is hosted on Earthlink (frankly, I didn't even know they were still around)...I have set up a MySQL database on their server (twice with the support agents assistance) but when I try and create a connection (using their credentials), I keep getting "An Unidentified Error has Occurred). 2 hours on the phone at different times with their support people and nobody can figure it out.
Has anyone out there had any success with Earthlink and making a Connection to a database? I'm trying to set up PowerCMS on my customer's site and it just wont connect. I can FTP successfully though...
Here is the connection file:
$hostname_myConnection = "sql5c38a.carrierzone.com";
$database_myConnection = "contentDB_xxxxxx";
$username_myConnection = "username";
$password_myConnection = "password";
$myConnection = mysql_pconnect($hostname_myConnection, $username_myConnection, $password_myConnection) or trigger_error(mysql_error(),E_USER_ERROR);
Appreciate any input!