[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Default Web site and http://local host with MySQL

Posted on 2011-10-21
Medium Priority
Last Modified: 2012-08-14
Hi, Way back when i set up our Local Intranet (IIS6) Windows 2003 std, i deleted the Default Web Site and created a web site with a new name which lives on the E Drive.
If i enter http://localhost i get page cannot be displayed, to view the website on the server i enter http://<ipaddressofserver>. Client PC's can access the website fine by its hostname.
I plan to introduce a members area to our Intranet so i have installed php5.2 and mysql5.5 and will download a software bolt on that is wizard based as i dont know SQL.
After i had installed  Mysql and ran the My SQL Administrator , i wasnt able to enter the hostname or ip address of the server in the server host field, but had to enter localhost. As http://localhost doesnt work as i deleted the Default WebSite, i guess its going to cause me problems having MySQL set to localhost?
Hopefully that sort of makes sense.
Question by:Rick_Penney
  • 4
  • 2
LVL 60

Accepted Solution

Kevin Cross earned 2000 total points
ID: 37007446
It sounds like potentially you are dealing with multiple IP addresses. In IIS, you have the option to have IIS serve its pages to all bound addresses or just one in particular. If you change that, then http://localhost should work just fine. Further, MySQL is database and not web, so its port is typically not 80 by default; therefore, its hostname and port should not collide. Consequently, you have the same option for MySQL to set which IP address it is bound to via its bind-address option.

Author Comment

ID: 37010665
The Server has 2 network cards, one of which is disabled.
I looked at the properties of the website and on the tab which shows the ip address of the server, i clicked on Advanced, in the Multiple identities for this website was just the ip address of the server, i clicked on add and added All Unassigned, port 80 to this list which added the entry default, port 80.
http://localhost/ now works correctly,  many thanks for that.
My SQL is set to port 3306, i'll look at the binding when i'm back in the office on Monday.
Thanks again for your quick reply and detailed explanation.

Author Comment

ID: 37011089
I've requested that this question be closed as follows:

Accepted answer: 0 points for Rick_Penney's comment http:/Q_27409012.html#37010665

for the following reason:

quick reply and good explanation, thank you.
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 37010674

Sorry i clicked on the wrong accept as solution, please can you reward all point to mwvisa1: and thank you for your help
LVL 60

Expert Comment

by:Kevin Cross
ID: 37011086
Glad that helped, Rick_Penney! Objecting to the auto-close, as that should allow you to select proper comment http:#37007446 as solution.
Best regards and happy coding,


Author Closing Comment

ID: 37011420
Thanks again for all your help, regards , Rick

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A phishing scam that claims a recipient’s credit card details have been “suspended” is the latest trend in spoof emails.
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month20 days, 2 hours left to enroll

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question