This blog post will highlight the key steps to install the MySQL Community Server and MySQL Workbench (GUI) to managing and administrating the MySQL server through a graphical user interface.

Step 1: MySQL community Server (v5.5)
Go to this URL, http://dev.mysql.com/downloads/mysql/
Download ‘Windows (x86, 32-bit), MSI Installer’ or ‘‘Windows (x86, 32-bit), MSI Installer’ depends on your machine spec under generally available (GA) release tab. Run the installer and follow the wizard to install the MySQL Server your machine.

Step 2: MySQL Workbench (GUI tool)
Go to http://dev.mysql.com/downloads/workbench/
Download ‘Windows (x86, 32-bit), MSI Installer’ under generally available (GA) release tab. Run the installer and follow the wizard to install the MySQL Server your machine.
Once installed successfully, Run the MySQL Workbench. Create a new connection with a host as localhost (or 127.0.0.1) with the username and password you choose at the time of installation. Click on test connection button to test the connection if successful then its shows message as ‘connection successfully’