How to configure MySQL server 5.1 on Windows



After installing MySQL 5.1 on Windows, we will need to configure it. This article provides step-by-step MySQL server 5.1 configuration guide on Windows as a development box.

If you want to install multiple versions of MySQL on the same box, read this article How to install two different versions of MySQL on the same computer for more info.

1. Start MySQL Server Instance Configuration Wizard.

If you have selected the checkbox 'Configure the MySQL Server now' in the last step when installing MySQL 5.1, the configuration wizard should start automatically when you click the Finish button.

Alternatively, you can launch the wizard from Start menu. Start -> Programs -> MySQL -> MySQL Server 5.1 -> MySQL Server Instance Config Wizard.

2. Select configuration type.

Select Detailed Configuration here. If this is the only MySQL server installed on your computer, you can select Standard Configuration.

3. Select a server type.

As this MySQL server is running on a development box, select Developer Machine as the server type.

4. Select the database usage.

Depends on the purpose of your development box, you can select either Multifunctional Database or Transactional Database Only.

Here we selected Transactional Database Only.

5. Set InnoDB table space settings.

InnoDB table type is the storage engine for a transactional database. Use the default settings here.

6. Set the database engine's concurrent connections option.

Here we selected Online Transaction Processing (OLTP) as it is the most common use of MySQL server.

If the MySQL server on your development machine is used for decision support such as data warehousing or data mining, select the first option.

7. Set networking options.

By default, make your selection the same as screenshot below. If port 3306 has been used by another instance of MySQL server, you can select port 3307 or a different port. This will allow two instances of MySQL server to be accessed via different ports on the same box.

8. Select the default character set.

By default, the Standard Character Set is selected, but you may want to select the second option - Best Support For Multilingualism. This allows our database to store text in many different languages.

9. Install MySQL server as a Windows service.

Below is the recommended way to run MySQL server on Windows. Making the service name as MySQL51 clearly identifies the service as a MySQL server version 5.1 database engine because you might install other versions of MySQL server on the same machine.

You might also want to check Include Bin Directory in Windows PATH if you want to operate MySQL from command line.

10. Set the root password.

Set a new password to the root account. Enter the same password to all three boxes. See below.

Don't select the Create An Anonymous Account checkbox. This can lead to an insecure system.

11. Ready to execute the configuration.

Now everything is ready to execute. Click [Execute] button.

12. Configuration successfully completed.

The configuration file has been created successfully. Click [Finish] to close the wizard.

Happy Configuring!


Copyright© GeeksEngine.com

Related Articles: 1. Steps to install PHP 5.x on Windows as a development machine 2. How to install Apache 2.x web server on Windows 3. How to connect two different versions of MySQL server on the same computer 4. How to install MySQL server 5.1 on Windows with screenshots 5. Five ways to create include path for PHP 6. How to use Date and Time data as integer value in PHP and MySQL 7. How to use Apache Virtual Host to run multiple local websites on Windows 8. Install all PEAR packages by yourself 9. How to install PEAR on Windows 10. How to use PHP and Microsoft SMTP Virtual Server to send emails 11. How to install PHP server-side scripting language on Windows 12. How to install Apache 1.3 web server on Windows 13. How to install two different versions of MySQL server on the same PC 14. How to configure MySQL server 4.1 on Windows 15. How to install MySQL server 4.1 on Windows with screenshots 16. Export Northwind Access database to MySQL via ODBC Other Recent Articles from the WAMP & LAMP category: 1. How to install MySQL Server 8 on Windows 2. How to resolve Apache web server port 80 access problem 3. The free tools I use to build PHP and MySQL websites 4. Steps to install PHP 5.x on Windows as a development machine 5. How to install Apache 2.x web server on Windows 6. How to connect two different versions of MySQL server on the same computer 7. How to install MySQL server 5.1 on Windows with screenshots 8. How to upgrade from PHP4 to PHP5 9. How to load time zone data for MySQL on Windows 10. How to use Apache Virtual Host to run multiple local websites on Windows 11. Install all PEAR packages by yourself 12. How to install PEAR on Windows 13. How to use PHP and Microsoft SMTP Virtual Server to send emails 14. How to install PHP server-side scripting language on Windows 15. How to install Apache 1.3 web server on Windows 16. How to install two different versions of MySQL server on the same PC 17. How to configure MySQL server 4.1 on Windows 18. How to install MySQL server 4.1 on Windows with screenshots 19. How to set up DSN in ODBC Data Source Administrator on Windows