Red Antigua Logo
Yet another piece of web.
Search this site (by Google)
Tools    (top)
Your IP
Check a site for broken links
(W3C)

Perl modules    (top)
Tree::Numbered::Tools
(CPAN)
Perl tutorials    (top)
Perl modules
HTML::Template
CGI::Application
Cookies with CGI::Application
Upload files with CGI::Application
Download files with CGI::Application
Redirect with CGI::Application
CPAN shell
Install DBD::mysql from the CPAN shell
Perl trim function
Validate an IP with Perl
Run suid Perl scripts under Apache
Perl taint mode
Perl date functions with Date::Calc

In Spanish
Curso de Perl

C tutorials    (top)
C - Introduction
C - Absolute beginner's Emacs
C - Examples for beginners
C - Makefile examples
C - Autotools examples
Server configurations    (top)
DNS
Apache
Apache Authentication and Access Control
mod_perl on FreeBSD
MySQL
MySQL add account
phpMyAdmin
Squid
DHCP

UNIX on Windows    (top)
MSYS2 - UNIX environment for MS Windows 32/64 bits
Apache setup on Windows
MySQL setup on Windows
PHP setup on Windows
Perl setup on Windows
Emacs setup on Windows
PuTTY
WinSCP
GIMP on Windows
MinGW - gcc on Windows
MSYS - UNIX-styled shell on Windows
msysDTK - autotools on Windows
GDB for MinGW on Windows

Misc. FreeBSD/UNIX    (top)
'portupgrade' on FreeBSD
'ipf' on FreeBSD
'pf' on FreeBSD
'su' on FreeBSD
Mount an ISO image under FreeBSD
Load the correct sound driver under FreeBSD without knowing what sound card you are using
Simultaneous sound channels on FreeBSD
FreeBSD network stuff
DOS-to-UNIX file conversion
favicon.ico on UNIX
Emacs tips
Command Line Calculator
Save multimedia streams with 'mplayer'
xargs - solution to 'Argument list too long'
Process multiple images from the command line using 'ImageMagick'
Turn the system bell off under X Windows
Process each line in an input file from the command line (or in a shell script)
How to keep a program running in the background using 'nohup'
How to remove symbolic links in the current directory using 'find' and 'rm'
How to remove Emacs backup files in the current directory and all subdirectories using 'find' and 'rm'
How to execute .profile without logging in
Configure X to handle non-English characters
How to move /var to /usr/var

Redirect a web page    (top)
Redirect to another web page
Apache redirect
C redirect
Perl redirect
PHP redirect
HTML redirect
JavaScript redirect

Javascript    (top)
Trim function
Login form
Register form
Popup window

MySQL setup on Windows
MySQL setup on Windows
This tutorial describes how to setup MySQL on Windows (tested with MySQL 5.0.21 on Windows XP Professional).

Install
Download the precompiled Windows version of MySQL from http://dev.mysql.com/downloads/ (look for a link to the the community downloads).
Extract the downloaded .zip file, which contains one single setup.exe file, and install as any other installation procedure.
MySQL will work fine without changing any default option during the installation wizard.
Anyhow, if you plan to do C programming, check the Developer Components option, to install C headers and libraries.
You can also add the Developer Components option (or add/remove/modify any option) to an existing MySQL installation by executing the setup.exe file again.

I plan to use multi-lingual contents in my databases, so I changed the default MySQL charset, Latin1, to UTF-8.
While this does not affect MySQL directly, it may affect the configuration of MySQL administration tools such as phpMyAdmin, so check out the tutorial about PHP setup on Windows for details.

The easiest way to test the installation is to run the MySQL Command Line Client:
Start » All Programs » MySQL » MySQL Server » MySQL Command Line Client
It asks for the root password, and if it is accepted and you see a help message, MySQL is up and running.

Last modified: Wed Sep 7 06:50:05 EDT 2016