MySQL problem with 1and1 hosting

Report · Mar 03, 2011

I have just discovered this group. I posted a similar post in the Dreamweaver area, but it probably needs to

be here.

I was asked to add database functionality to a website hosted by 1and1. I just started to use DW CS5

recently and when I tried to connect the MySQL db using Dreamweaver, I got the 404 file not found error

message. It has been a while since I have worked with PHP and MySQL, but I have used MySQL many times in the

past using DW CS4 and using 1and1, so I know that it used to be possible.

Here is what I have done so far:
Tried to connect using DS CS5. Tried to connect using DW CS4. I contacted 1and1 and they told me that they

no longer allow MySQL to connect using Dreamweaver. However, they sell DWCS4 software to be used with their

higher end hosting packages (which I am using).

Here are my questions:
1) Is this a known problem with 1and1? If so, is the DW that they sell altered to get around this?

2) Is this how other hosting companies are going, or is this only true of 1and1?

Report · Mar 03, 2011

RobertBoy wrote:
Tried to connect using DS CS5. Tried to connect using DW CS4. I contacted 1and1 and they told me that they
no longer allow MySQL to connect using Dreamweaver.

This means that they disabled remote access to their MySQL server for security reasons, meaning that you´ll have to...

1. set up a local testing server (eg. MAMP, XAMPP) and develop/test your work locally

2. upload the finalized files to the remote server and run them from there.

If so, is the DW that they sell altered to get around this?

Unlikely, because the product EULA declares a "No Modification" restriction.

Is this how other hosting companies are going, or is this only true of 1and1?

This is not uncommon with shared hostings in particular, though there may be some which allow remote access. Let´s hope that other forum participants can provide recommendations.

Report · Mar 03, 2011

About 3 years ago, I installed WAMP on my computer. Since then I have upgraded and now use Win 64 bit. Should I use Wamp64 or XAMPP?

It seems that should be the route I need to go - I had actually considered it, but didn't really want to have to do that again.

Report · Mar 03, 2011

About 3 years ago, I installed WAMP on my computer. Since then I have upgraded and now use Win 64 bit. Should I use Wamp64 or XAMPP?

Can´t provide a reasonable answer, because I have never used WAMP and my OS is still Win XP. However I assume that using Wamp64 might be more familiar to you.