[thelist] DB Server

Todd Richards todd at promisingsites.com
Thu May 13 20:25:28 CDT 2010


Thanks Hassan - I appreciate your thoughts very much!

Todd

-----Original Message-----
From: Hassan Schroeder [mailto:hassan.schroeder at gmail.com] 
Sent: Thursday, May 13, 2010 4:00 PM
To: todd at promisingsites.com; thelist at lists.evolt.org
Subject: Re: [thelist] DB Server

On Thu, May 13, 2010 at 1:16 PM, Todd Richards <todd at promisingsites.com>
wrote:

> So I'd like to get this worked out so that I have one
> MSSQL DB server, one MySQL DB server, and then the server for my sites.

> But I'm guessing, just like IIS, you have to tell the server "something"
so
> that it will accept those requests.

Unless you start MySQL with skip-networking, it listens on port 3306.
Make sure your firewall allows access to that port. That's basically it.

You probably want to limit access to that port to the IPs of your web
servers, and have a strong password on an account with the minimum
necessary authorizations. But there's probably plenty you can find to
read on securing your DB server.

Don't know anything about MSSQL but it should be roughly the same.

HTH,
-- 
Hassan Schroeder ------------------------ hassan.schroeder at gmail.com
twitter: @hassan




More information about the thelist mailing list