Installing Mysql Community Server 5.1 - Windows

Installing MySQL Community Server 5.1 – Windows Vista

MySQL Clustering

Installing MySQL Community Server 5.1 – Windows Vista Objective To install MySQL Community Server 5.1 in Windows Vista.

Pre-requisites 1. Download MySQL Community Server 5.1 from http://dev.mysql.com/downloads/mysql/5.1.html#downloads

Assumptions 1. There isn’t any version of MySQL installed on the system.

Procedure Installation 1. The installation of MySQL – Community Server on Windows is reasonably simple and is entirely based on Graphical User Interface (GUI). 2. Download the binary for Windows from the above mentioned URL and double-click it to start the installation.

Installing MySQL Community Server 5.1 – Windows Vista

3. The installer opens up with the welcome page.

MySQL Clustering

Installing MySQL Community Server 5.1 – Windows Vista

MySQL Clustering

4. Mention the setup type, which is typical, complete or custom. Typical installs the components that are frequently used by a majority of developers. Complete installs all the components and Custom allows the user to install the components on the jurisdiction of the developer.

5. Custom installation provides the developer with the choice of installing the server, client program, instance manager, documentation and the developer components. By default developer components aren’t installed.

Installing MySQL Community Server 5.1 – Windows Vista

MySQL Clustering

6. Select the components which you wish to install and proceed to the next step. A complete summary of the installation and configuration paths are provided now.

Installing MySQL Community Server 5.1 – Windows Vista

7. Click next to start the installation.

MySQL Clustering

Installing MySQL Community Server 5.1 – Windows Vista

MySQL Clustering

8. After the installation finishes, an advertisement of the MySQL Enterprise edition is displayed.

9. After viewing the message, the setup wizard concludes with an option to configure the MySQL Server. It is recommended to configure the server at installation time.

Installing MySQL Community Server 5.1 – Windows Vista

MySQL Clustering

10. Under certain circumstances, it is possible that the configuration wizard might not start. In such situations, the configuration wizard can be started by navigating to Start -> MySQL -> MySQL Server 5.1 -> MySQL Server Instance Config Wizard.

Installing MySQL Community Server 5.1 – Windows Vista

MySQL Clustering

Installing MySQL Community Server 5.1 – Windows Vista

MySQL Clustering

Configuration 1. MySQL Server can be easily configured with the Config Wizard provided as a part of the MySQL Installation.

2. If there is already a MySQL instance, it is possible to reconfigure it from this wizard or a new one may be created. The sequence of steps is pretty much same for both of them. It is also possible to remove an already running server instance.

Installing MySQL Community Server 5.1 – Windows Vista

3.

MySQL Clustering

There are two ways in which the server instance can be configured – Standard and Detailed.

Installing MySQL Community Server 5.1 – Windows Vista

MySQL Clustering

4. The detailed configuration wizard provides greater flexibility to tune the server according to our requirements. The MySQL server can be tuned with respect to memory, CPU and disk usage by specifying the machine as a developer, server or a dedicated MySQL server machine.

5. MySQL server can be configured with respect to transaction management with the help of the storage engines – high speed MyISAM and fast transactional InnoDB.

Installing MySQL Community Server 5.1 – Windows Vista

6.

MySQL Clustering

The InnoDB datafiles will be placed by default at the install directory. It can be changed when configuring MySQL for the first time and can be modified when the configuration wizard is run at a later time.

Installing MySQL Community Server 5.1 – Windows Vista

7.

MySQL Clustering

MySQL has the capacity to manage the incoming requests and restrict the maximum number of concurrent connections.

Installing MySQL Community Server 5.1 – Windows Vista

MySQL Clustering

8. The default port number of MySQL is 3306. However this can be changed with the help of this configuration wizard.

Installing MySQL Community Server 5.1 – Windows Vista

9. MySQL has extensive support for Internationalization.

MySQL Clustering

Installing MySQL Community Server 5.1 – Windows Vista

MySQL Clustering

10. MySQL is installed as a Windows Service which starts automatically at boot time. Also the bin directory can be added to the system path.

11. In the next step, the root password can be changed. If MySQL is being installed for the first time, just enter the new password. Else if MySQL is being reinstalled, the old root password is still valid and is required to be specified when changing the password.

Installing MySQL Community Server 5.1 – Windows Vista

12. A summary of the steps for configuration is specified in the next step.

MySQL Clustering

Installing MySQL Community Server 5.1 – Windows Vista

13. Click on execute to start the configuration

14. The configuration process may take a little time to finish.

MySQL Clustering

Installing MySQL Community Server 5.1 – Windows Vista

MySQL Clustering

15. Navigate to Start -> MySQL -> MySQL Server 5.1 -> MySQL Command Line Client and specify the new root password to login.

Installing MySQL Community Server 5.1 – Windows Vista

MySQL Clustering

NOTE – Though the above screen-shot uses Vista as the Operating System, the installation procedure remains the same for all versions of Windows, including the server editions like Windows Server 2003.