How to install MySQL server 4.1 on Windows with screenshots




MySQL is the world's most popular open source Relational Database Management System (RDBMS). This article provides step-by-step installation guide for MySQL 4.1 (release 4.1.18) on Windows as a development machine. Other releases of MySQL 4.1 should have similar installation process.

Note that, to run queries in MySQL Tutorial Practices, you need to install MySQL version 5+. The installation process is similar to MySQL 4.1 listed here.

What you need

1. MySQL 4.1 release 4.1.18 (other releases for version 4.1 should be fine).
2. Windows 2000 or XP (may work on Windows 9x but never tested).

Why MySQL version 4.1

This guide is based on MySQL version 4.1 release 4.1.18 for two reasons.

• First, starting with MySQL 4.1.5, MySQL provided Installation Wizard and MySQL Configuration Wizard (in Windows Installer format, 21 Sep 2004, 13.3MB). The wizards are designed to install and configure MySQL in such a way that new users can immediately get started using MySQL.

• Second, MySQL server version 4.1 provides more functionalities (such as subqueries and derived tables) that are not available in previous versions.

Step #1: Download MySQL 4.1.18

1. Download MySQL 4.1.18 (1 Jul 2005, 25.1MB)

   Filename: mysql-essential-4.1.18-win32.msi

   MD5 checksum: 40be516916b82b4b6af699ec3873917f (What's this?)

   For archives of various MySQL versions, click here.

Step #2: Install MySQL

Double click mysql-essential-4.1.18-win32.msi to start installing MySQL. You will go through a setup wizard so it's fairly simple. Just follow the installation instructions step by step. The process has 6 steps.

1. Welcome to the Setup Wizard for MySQL Server 4.1. Click Next to continue.

   

2. Select a setup type - Typical, Complete, Custom. Select Typical and click Next. The default insllation directory will be C:Programs FilesMySQLMySQL Server 4.1.

   

3. Ready to install MySQL. After review the settings, click Install. If you want to change any settings, click [Back] button.

   

4. Installation in progress.

   

5. MySQL.com Sign-Up. If you don't want to sign-up at this stage, select Skip Sign-up and click Next.

   

6. Setup Wizard Completed. Make sure you have selected 'Configure the MySQL Server now' checkbox if you want to configure it after click Finish button.

   

What's next

Unlike version 4.0, MySQL 4.1 provides an easy-to-use wizard to configure MySQL server instance. Next, we are going to go thru the steps of MySQL server configuration process. See How to configure MySQL server 4.1 on Windows.

Copyright© GeeksEngine.com

Related Articles: 1. How to export Northwind Access database to MySQL 2. How to set up MySQL DSN in ODBC Data Source Administrator on Windows 3. How to configure MySQL server 4.1 on Windows 4. How to install two different versions of MySQL server on the same PC 5. Step by step guide on how to install Apache web server on Windows 6. How to install PHP on Windows as part of WAMP installation 7. How to use PHP and Microsoft SMTP Virtual Server to send emails on Windows 8. How to install PEAR on Windows 9. How to install PEAR on your shared web hosting account 10. How to use Apache Virtual Host to run multiple local websites on Windows Other Recent Articles from the WAMP & LAMP category: 1. How to upgrade from PHP4 to PHP5 2. How to load time zone data for MySQL on Windows 3. How to use Apache Virtual Host to run multiple local websites on Windows 4. How to install PEAR on your shared web hosting account 5. How to install PEAR on Windows 6. How to use PHP and Microsoft SMTP Virtual Server to send emails on Windows 7. How to install PHP on Windows as part of WAMP installation 8. Step by step guide on how to install Apache web server on Windows 9. How to install two different versions of MySQL server on the same PC 10. How to configure MySQL server 4.1 on Windows