How to configure MySQL server 4.1 on Windows as a development box.

How to configure MySQL server 4.1 on Windows

MySQL is the world's most popular open source Relational Database Management System (RDBMS). This article privodes step-by-step server configuration guide for MySQL 4.1 (release 4.1.18) on Windows as a development box.

What you need

You should have installed MySQL 4.1 release 4.1.18 (other releases for version 4.1 should be fine). If not, see How to install MySQL 4.1 on Windows.
Windows 2000 or XP (may work on Windows 9x but never tested).

Note that we assume you don't already have another instance of MySQL server installed on your computer. MySQL 4.0 and 4.1 can be installed on the same box. See How to install two different versions of MySQL on the same computer for more info.

Start MySQL Server Instance Configuration Wizard.

If you have selected the checkbox 'Configure the MySQL Server now' in the last step when installing MySQL 4.1, the configuration wizard should start automatically when you click Finish button. Alternatively, you can launch the wizard from Start menu. Start -> Programs -> MySQL -> MySQL Server 4.1 -> MySQL Server Instance Config Wizard.
Select configuration type. Because you do not already have another MySQL server installed, choose Standard Configuration.
Select Install as Windows Service. This is the recommended way to run the MySQL server on Windows. If you want to operate MySQL server from command line, check the second checkbox - Include Bin Directory in Windows PATH.
Set a new password to root account. When MySQL was installed, the password for root account was blank. Now it is time to set a new password to it. Don't select the Create An Anonymous Account checkbox. This can lead to an insecure system.
Now everything is ready to execute. Click Execute button to run it.
MySQL server configuration completed successfully.

Note: You can always change the configurations by going through the wizard again. To launch the wizard:

Start -> Programs -> MySQL -> MySQL Server 4.1 -> MySQL Server Instance Config Wizard.

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 install MySQL server 4.1 on Windows with screenshots
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 install MySQL server 4.1 on Windows with screenshots

	Custom Search