Remote connection issues with MySql and Earthlink ! `

HI Ray, So I have updated my Software to DB 2 with you. Thank you. However I am running into a problem making connections to the remote database hosted on earthlink. For now, the local host works from the website itself but I cannot connect to make updates via Dreamweaver and WA remotely. This isn't just true in DW, but also in Navicat. The issue is that the sites are using php 5 being updated to 7 and the connection scripts are breaking when they do. But to run WA, I need to be able to connect remotely. Right now, DW's failure to establish a connection has put DW into a loop.

I am trying to work it out with EL and I wish I could get my client to move from them! Their tech support is terrible and very very slow (weeks) .
Wondering if you have any ideas? First attachment is WA in failed connection. 2nd 2 are connection errors in Navicat, the first using standard connections, the second using SSH. DW doesn't seem to give me a connection log or I don't know where to find it.
4th image is current db url they sent yesterday, which is for remote while the 5th is what works in the connection script for now from the website itself, but which breaks when updated to php 7 and mysqli


BTW, WA keeps trying to make the connection to the DB and I can't cancel out of it or get a log from it. I press cancel and it starts another attempt.

The error implies that the username or password are incorrect. That isn't something that I could help with since I can't verify your credentials.

Are you able to connect on live web pages? If so, then the issue may be the host name and not the username or password.

If you had a connection working anywhere else (a web page, etc.) then I could take a look and figure out why it doesn't work in Dreamweaver, but when it doesn't work anywhere it strongly suggests the username or password are incorrect. Perhaps try resetting them.

Are you able to connect with phpMyAdmin? What is the host name that appears on the top of the page in phpMyAdmin? That is the one you should use in your dreamweaver connection. Dreamweaver doesn't actually need a Remote connection to the database. It uses FTP to upload a web page to the server and connects directly through a url, so sometimes "localhost" will work in Dreamweaver when navicat requires a full domain.

Are you able to connect on live web pages? If so, then the issue may be the host name and not the username or password.

Yes the live web pages connect. Remote does not. Seems like Earthlink doesn't know what it is doing.

If you post your phone number in the private area then I'll call you and do a screen share to help you get this working.

thanks Ray. The issue is though if EL doesn't have the correct info for connections to their db server, I don't know if we are able

What do you think?

Originally Said By: Above

  Dreamweaver doesn't actually need a Remote connection to the database. It uses FTP to upload a web page to the server and connects directly through a url, so sometimes "localhost" will work in Dreamweaver when navicat requires a full domain.  

There are really only two things that need to be correct for dreamweaver to connect to your database:
Your Testing Server in dreamweaver (usually issues are with a bad Server URL)
Your Database Credentials (if it works on your live site, the credentials are correct. You can get the correct server name from the top of your phpMyAdmin page while viewing the database)

In your case you had a missing https;// in front of your testing url and the server host was set to the wrong domain. Correcting these two issues allowed dreamweaver to connect to your database.