Server Admin

Use SSH to Create Secure Tunnels for File Transfers (SFTP), Remote Desktop (VNC), Subversion (SVN), and Firefox Traffic

This guide will show you how to access a computer located on your home network from outside of your local area network. For the purposes of this guide, let’s assume we are trying to access a HOME SERVER such as a Mac Mini located on your home WiFi router. The home computer could just as easily be a Ubuntu, or similarly flavored Linux machine. The first thing that we will need to do is determine your home IP address, and then we will setup port forwarding on your wireless router. Keep reading to get started with this process or go to learn how a SSH Tunnel works.

Read full article by Franklin

Using phpMyAdmin to manage MySQL

phpMyAdmin

Odds are, if you design Web sites with a database backend, you've worked with MySQL. You can manage this database from the command line, but it's not very user-friendly. Using the graphical tool phpMyAdmin helps, but not all Web hosting providers offer it or allow you to install it on the server. Fortunately, you can install it on your own box and manage several MySQL databases remotely at the same time, without having to install anything anywhere else.

Linux.com

Installing WAMP server on Windows

WAMP is a package with Apache, mySQL, PHPmyAdmin and PHP 4 /5. It is what you need to run any dynamic websites in a testing environment.

Here is a videocast to show you how to install WAMP on Windows: http://quartz.syr.edu/rdlankes/Teaching/LAMP/WAMP/WAMPInstall.html