close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Remote connection issues with MySql and Earthlink ! `

Thread began 8/21/2020 9:41 am by Peterson Design Studio - jefferis | Last modified 8/21/2020 1:52 pm by Ray Borduin | 36 views | 5 replies |

Peterson Design Studio - jefferis

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.

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post
Did this help? Tips are appreciated...

Peterson Design Studio - jefferis

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.

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post
Did this help? Tips are appreciated...

Peterson Design Studio - jefferis

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?

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post
Did this help? Tips are appreciated...

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...