Lintrack As A LAN Gateway And An OpenVPN Bridge

This tutorial will guide you through installation and configuration of Lintrack, a GNU/Linux distribution specialized in networking tasks. We will give two LANs access to the internet along with DHCP and DNS cache servers, and then we will connect our networks using OpenVPN in bridging mode. You should be running all these in well under an hour, thanks to the unified configuration interface of Lintrack.

Read More.........

Disk Based Backups With Amanda On Debian Etch

This document describes how to set up Amanda (The Advanced Maryland Automatic Network Disk Archiver) on Debian Etch. For this tutorial I chose Ubuntu v7.04 as a backup-client. The resulting system provides a flexible backup-system with many features. It will be able to back up multiple hosts via network to various devices. I chose the disk based backup for this howto.
Read More...........

I forgot the MySQL root password, how do I reset it?

The Mysql root password can be set using the following procedure:

1.
Stop the MySQL service:

# service mysqld stop

Example output:

#service mysqld stop
Stopping MySQL: [OK]

2.
Start MySQLwith:

# /usr/bin/safe_mysqld --skip-grant-tables &

On Red Hat Enterprise Linux 4, safe_mysqld has been changed to mysqld_safe.

Note: safe_mysqld is a shell script which invokes mysqld, but additionally traps any forceful
terminations of the MySQL server and avoids any database corruption.

3.
Change the password of the root user:

# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('new_password') WHERE user='root'
mysql> FLUSH PRIVILEGES;
mysql> exit;


4.
You could perform Step 1 here and avoid using step 4, but in some cases, the startup script may not
behave as expected since mysqld was started directly, i.e. not using the init script.

# mysqladmin shutdown

5.
Start the MySQL service:

# service mysqld start

Example output:

# service mysqld start
Starting MySQL: [ OK ]