[thelist] DB Server

Hassan Schroeder hassan.schroeder at gmail.com
Thu May 13 16:00:12 CDT 2010

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.

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

More information about the thelist mailing list