Blogs

Like this
grant all privileges on db.* to 'user'@'host' identified by 'password';

Execute ipconfig /flushdns on command prompt

Probably impossible to list all, but here are really harmful if you are moving it to other server:

1. Install /usr/ports/ports-mgmt/portaudit in order to receive vulnerability reports with daily security reports
2. Install /usr/ports/ports-mgmt/portupgrade in order to be able to update ports in easier way
3. When you need to upgrade ports
   • portsnap fetch
   • portsnap update (or portsnap extract if using portsnap for the first time)

a2enmod ssl

To extract private key:

• openssl pkcs12 -in file.pfx -nocerts -out pk.pem
• openssl rsa -in pk.pem -out key.pem

To extract certificate:

• openssl pkcs12 -in file.pfx -clcerts -nokeys -out cert.pem

Start Configuration Manager (separate program with that name), go to "SQL server network configuration", choose "Protocols" bellow that - right click TCP/IP and click enable if not enabled already. Right click it again - choose properties this time, choose no for "listen all" unless you are exposing service to other machines, then on next tab choose "Enabled" for addresses you want to listen on (::1 and 127.0.0.1 make sense). Make sure you delete "TCP dynamic ports" and set 1433 for "TCP port" value. Also make sure that your web.config files contain 127.0.0.1 for server address.

Linux firewall divides all traffic into 3 groups

• INPUT
• OUTPUT
• FORWARD

First two are obvious, third group I guess also covers nat and similar features.

Traffic is controlled by adding accept or reject rules to appropriate group - compared to OpenBSD's pf iptables seems to be missing tables (weird choice for name, he he), all rules seem to behave like quick rules and you need explicitly to take care of connection state.

dpkg -i filename.deb

Since I wasn't really able to find information how to set this up on one place here is short recipe.

Prerequisites: