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:
<?php
# FileName="WADYN_CONN.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_myConnection = "sql5c38a.carrierzone.com";
$database_myConnection = "contentDB_xxxxxx";
$username_myConnection = "username";
$password_myConnection = "password";
@session_start();

$myConnection = mysql_pconnect($hostname_myConnection, $username_myConnection, $password_myConnection) or trigger_error(mysql_error(),E_USER_ERROR);

?>


Appreciate any input!

Paul

Does your host have a cpanel with a way to connect to the database using phpMyAdmin?

when connected using phpMyAdmin, look in the top right of the screen, it show the server name and database name.

use that server name in the connection file.

Jason,

I believe I am using the server name, but if I didn't put it in the right place, please advise. I've attached a screen capture of the phpmyadmin page.

Looks like you have the correct server name, there must be a problem with one of the other settings.


double check the testing server settings and make sure they are correct. One of your settings is off either in the testing server or the connection.

The testing server was local on my computer. I unchecked it in the DW settings, but that didn't make a difference.

But all my credentials are copy and paste from their phpmyadmin page...so I'm still not sure what is up with them. They are escalating it to a level 3, believe it or not.

you need to have a testing server defined, and it needs to point to the remote PHP server

Jason,

I made the connection successfully. The URL in my settings wasn't correct.

So, I put in the PowerCMS and I thought it installed it, but the install_cms/index.php file is not there. Where are the instructions for installing PowerCMS on the server?

Thanks

when you add power CMS to a page, it should add the power CMS files to the site on your computer, you then need to upload all of the power CMS files to the server and start the installation.

make sure all the site files are being uploaded.

Ok. Forgot that. I did that now...and the installation stops at the database.php page. Did I not include something?

See PM

See PM