close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Connecting to MySQL database on Earthlink

Thread began 2/12/2014 12:30 pm by Paul | Last modified 3/06/2014 4:52 pm by Paul | 1464 views | 22 replies |

Paul

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

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

Paul

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.

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

Paul

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.

Sign in to reply to this post

Jason ByrnesWebAssist

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

Sign in to reply to this post

Paul

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

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

Paul

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

See PM

Sign in to reply to this post

Jason ByrnesWebAssist

See PM

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...