MainelyDesign.com Blog

Manually Installing MySQL on Windows 2003 Server

Posted on 09/02/2009 at 12:02 pm by Kevin Wentworth
Viewed 8,104 times | 0 comments

I have been trying to install MySQL on a web server running Windows 2003 for quite a while now.  I was finally successful! Here's how I did it...

Does your server have a hard-coded IP address?

If so, you need to make localhost refer to the manually assigned IP address in your hosts file.  This file is located in C:\Windows\System32\drivers\etc.

Default hosts file will say:

  1. 127.0.0.1   localhost

Modify your hosts file to reflect the binded IP address (be sure to save your changes!):

  1. 10.1.1.x    localhost #or whatever your binded IP address may be

This is the most important step.  This is why MySQL didn't work for out of the box.

It took me a while before I tried this.  If you keep getting 'Can't connect to MySQL server on localhost" errors and you don't have a firewall blocking port 3306, this is probably what's going on.  MySQL comes default with access granted to localhost.  However, if you've manually assigned an IP address to your server, MySQL WILL NOT WORK!

To test if this is working, go to the command prompt and type in "ping localhost".  You should see the IP address you entered above getting pinged, not 127.0.0.1.

Now the MySQL instructions should work as proscribed

The installation instructions at mysql.com will now work.

 

Bookmark and Share

Tags for Manually Installing MySQL on Windows 2003 Server

Mysql | Web Server Admin | Windows | Iis | Software

Comments for this Posting

No comments. Be the first to post a reply.

Sorry, comments are closed for this posting.

Please Email Kevin if you have any questions. Thanks!

Meet Site Avenger - Hosted Content Management System

Powered By: Site Avenger | Site Production: Saco Design