Other software and programs that I've found help give a better user experience when using your server.
FirewallsGet yourself a firewall. A good, free, easy-to-use one is Zone Alarm that monitors outbound as well as inbound traffic. I personally use the free firewall from Comodo. However, it is not as user friendly and it does require some technical know-how to take full advantage of it's features.
FTP ServerI previously recommended the trial version of G6/BulletProof FTP server until one of you readers pointed out a much better server. Now I highly recommend using the totally free GuildFTPd. Although it hasn't been updated in a while, it's still a great windows based program with tons of options.
Mail POP3/SMTP ServerThis is also a reader suggested program. MailEnable is a mail server for Win32 systems. The Standard (free) version has no ads and no forced signatures. The program has no limits on the number of domains or on the number of accounts.
MySQL data manipulationBecause of frequent requests, I'm going to give a simple 1-2-3 on how to install phpMyAdmin so you can use it to edit your MySQL databases and tables. If you want to install it "correctly" you should follow their official docs. If you want to get it working fast, do this:
- Download the latest version (note: 3.x will only work with mysql5+). There are "quick downloads" links at the top right.
- Extract it somewhere in your document_root (the folder where your html "web files" are). It creates it's own sub-folder which you might want to rename after extracting
- Rename the ugly long-tailed phpMyAdmin-2.9.2-all-languages-utf-8-only folder it created to something shorter like: phpmyadmin
- Edit the file phpmyadmin/libraries/config.default.php ignoring all the "do not edit" warnings and scroll down to about line 175. The lines you want to change/fill out are:
$cfg['Servers'][$i]['auth_type'] = 'config'; // change from 'cookie' to 'config' $cfg['Servers'][$i]['user'] = 'root'; // MySQL user $cfg['Servers'][$i]['password'] = ''; // MySQL password
- Load the thing up in your browser like http://localhost/phpmyadmin/ (or wherever you installed it to). REMEMBER: using the above instructions, anyone who can access that folder can change info stored in your database. If you are worried about that or want to set it up correctly, refer to the official documentation.