Ubuntu Server Auto Mysql Root Password Set

During the default LAMP installation of Ubuntu Gutsy Server, you will be automatically prompted to set the Mysql root user password. This is an extremely convenient feature, that consolidates an entire step. This feature among many other puts Ubuntu server edition at the top of my list for server environments. Although I currently use Debian for my server environment, I may choose to use Ubuntu to deploy a Ruby on Rails server environment.

Hardware Software Backup Importance

With a Virtual Server your hardware is backed up completely within the VDI image. Your Mysql databases, specifically for websites that are blogs update often; more often than you would like to backup your 50 Gigabyte VDI image. To compensate, and significantly ease backup procedures have your mysql databases backed up regularly. Daily, hourly, or even after each post is recommended in order to effectively secure needed files in case a system restore is required. To backup your mysql databases you can view my previous post:

http://www.bgevolution.com/blog/index.php/cron-server-backup-scripts/

Virtual Server Can Fool Hackers - Backup/Restore is Easy

When a virtual server is utilizing the host systems network, and receives an independent local IP via DHCP from your router it appears to be an actual computer form the outside world. If a backup of the VDI is kept regularly it can simply replace a damaged, or hacked system in the time it takes to copy a file. Virtual servers exist as a single VDI file, therefore for blogs that utilize database backends simply copy your backup server VDI image, boot, then use your phpmyadmin to update your mysql databases from your backups; obviously this entails keeping mysql database backups. For more information about mysql backups utilizing automated cron scripts see:

http://www.bgevolution.com/blog/index.php/cron-server-backup-scripts/

Mysql Set Root Password

This is a standard requirement of any new Mysql installation. First login:

mysql -u root -p

Press enter, with no characters entered, when you are prompted for the root password. The password is nothing. Then enter the following into the mysql prompt. Replace temp with your desired password:

SET PASSWORD FOR root@localhost=PASSWORD('temp');

ISPConfig Hosting Solution Debian Dependencies

While installing ISPConfig on a default Debian Gnome desktop the following dependencies were documented:

apt-get install apache2 php5 libapache2-mod-php5

apt-get install mysql-server mysql-client php5-mysql

apt-get install vsftpd quota bind flex spamassassin libmysqlclient15-dev zlib1g-dev

After these dependencies are met, ISPConfig can be compiled from source. Navigate to theISPConfig source code folder and type:./setupFollow the onscreen prompts accordingly.

If you have any issues you can follow the Howtoforge.com tutorial:

http://www.howtoforge.com/perfect_setup_debian_etch

Debian LAMP

Debian is great to minimize software on the hard drive. With a minimal Debian installation, and the following apt commands, you will have a completely setup LAMP system in about 5-10 minutes. Simply run the following commands to install the appropriate software.

This will install apache with php support:

apt-get install apache2 php5 libapache2-mod-php5

This will install mysql with php support:

apt-get install mysql-server mysql-client php5-mysql

These two apt installation lines will take care of everything, and your Debian system will work just as a Ubuntu LAMP installation.

WAMP (Windows, Apache, Mysql, PHP)

The webserver community is well accustomed to the LAMP terminology. WAMP is the equivalent for Microsoft Windows platforms. The main difference is that WAMP does not include Windows, and a License must be purchased separately if you don’t already have one. Otherwise there are a variety of WAMP software packages that will completely implement a full webserver utilizing dynamic PHP, and Mysql database backend support.

Once of the more popular WAMP software package can be found at wampserver.com. While the domain name of their website makes for easy Google-ability, there are other software package competing for territory. There are almost two dozen different pacakges that all provide an excellent, easy installation process to easily setup a complete webserver system on the Windows platform.