All Database HOWTOs

A quick and easy cheat sheet of the MySQL Database

Most home/SOHO administrators don't do any database programming, but they sometimes need to install applications that require a MySQL database. This HOWTO explains the basic steps of configuring MySQL for use with a MySQL-based application in which the application runs on the same server as the database.

DBDesigner 4 is a visual database design system that integrates database design, modeling, creation and maintenance into a single, seamless environment.

It combines professional features and a clear and simple user interface to offer the most efficient way to handle your databases.

Best of all, it is open source!

Documents the process of upgrading MySQL from 4.1.21 to 5.0.26. This Gentoo Linux specific.

Simple howto on FULLTEXT INDEX search using MySQL and MATCH/AGAINST keywords.

This is a description of how to set up a secure tunnel between your MySQL Server and a locally running MySQL Administrator using Putty. By creating a secure tunnel to your MySQL server using Putty, you can grant localhost access to powerful applications like MySQL Administrator while at the same time, make your server appear as if it isn't even there. In effect, make your MySQL server disappear from the outside world.