Skip to main content
A
Anonymous
November 15, 2007
Answered

DB connection and port 81

  • November 15, 2007
  • 1 reply
  • 1045 views
This question is based on an early one ( http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=12&catid=263&threadid=1314920&enterthread=y).

Because I have SQL Server on port 80 and have my WAMP running on port 81, I have had to specify my MySQL Server as LOCALHOST:3306 on my local system in order to establish my database connection. However it must be LOCALHOST at my Web Host's system. Since I can't establish a LOCALHOST connection locally, I have to set it remotely (after uploading my files.)

I'm wondering if it's possible to set port 81 as the default port on my system and if so, what are the drawabacks of doing this.

Or is there some other approach?

Or am I missing something here and making things more complicated than they are?

Thanks.
This topic has been closed for replies.
Correct answer
You two need some fresh air.

I don't need clarification for what I understand. I need clarification for what I don't understand. I don't need assistance for what works. I need assistance for what doesn't work.

If specifying localhost had worked initially, I wouldn't have started this post.

I take it either the default post can't be changed or you don't know how to do it either. I'll check over at MS.

1 reply

N
Newsgroup_User
Inspiring
November 15, 2007
"Minding" <george@minding.org> wrote in message
news:fhhl6q$4r6$1@forums.macromedia.com...
> This question is based on an early one
> ( http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=12&catid=2
> 63&threadid=1314920&enterthread=y).

You are very confused here
> Because I have SQL Server on port 80

I think you mean IIS

>and have my WAMP running on port 81,
that would be APACHE

> I have had to specify my MySQL Server as LOCALHOST:3306 on my local system
> in
> order to establish my database connection.

That is the default port for the MySQL server

> However it must be LOCALHOST at my Web Host's system.

LOCALHOST is an alias that should point to the 127.0.0.1 address which
always points to the local host.
In other words: localhost means this computer
This will be THAT computer on each different computer where localhost is
referred.

> Since I can't establish a LOCALHOST connection locally,

So you can't connect to YOUR localhost or to your webhosts localhost?

> I have to set it remotely (after uploading my files.)
>
> I'm wondering if it's possible to set port 81 as the default port on my
> system
> and if so, what are the drawabacks of doing this.

Default port for your system? If you have IIS running on port 80 you have to
bind Apache to another port yes, 81 is usually chosen for this purpose,
you specify the port in apache's configuration file
> Or is there some other approach?

You don't need a local WAMP if you want to develop on your IIS server, but
usually you develop the whole system on YOUR local system, then "freeze" the
system and deploy it to THEIR production environment.

> Or am I missing something here and making things more complicated than
> they
> are?

Although you can do development on a production system with Dreamweaver, it's
prone to (security) problems,
off course if your development environment is very different from your
production environment you might have problems in the deployment phase

> Thanks.


A
Anonymous
November 15, 2007
Not confused about IIS and Apache. Not confused about what Localhost is on this or another computer. Not confused about default ports and binding to 81. Not confused about doing development on a production system with DW.

Thanks for your effort, but you restated the problem without addressing my problem. I'll restate it using your words if it will help:

Because I have IIS on port 80 and have Apache running on port 81, I have had to specify my MySQL Server as LOCALHOST:3306 in DW when on my local system in order to establish my database connection. However on my production (Web Host's) system, I must specify LOCALHOST without the qualifying 3306 for MySQL. Is this true? If so, I have to make the change on my production system which is not an acceptable approach.

I'm wondering if it's possible to set port 81 as the default port on my system and if so, what are the drawabacks of doing this.

Or is there some other approach?

Thanks.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices