To install the MySQL server and workbench

  1. Go to the MySQL website at
    http://dev.mysql.com/downloads/mysql/

  2. Scroll-down to
    Windows (x86,64-bit), MySQL Installer MSI

    images/download/attachments/6046023/image2015-2-23_11_39_26.png


  3. Click on the Download button.

  4. Scroll-down to mysql-installer-community-x.x.xx.x.msi

    Note: MySQL Installer is 32-bit, but will install both 32-bit and 64-bit binaries.

    images/download/attachments/6046023/image2015-2-23_11_41_10.png

  5. Click the Download button.

  6. On the next page, click the No thanks, just start my download.

    images/download/attachments/6046023/image2015-2-23_11_45_4.png

    The .msi file starts downloading.

  7. Click the .msi file to run it and to configure the installer.

    The Welcome window is displayed.

  8. Select the Install MySQL Products action.

    images/download/attachments/6046023/image2015-2-23_11_46_28.png

  9. On the License Agreement page, click the I accept the license terms box and click Next.

    images/download/attachments/6046023/image2015-2-23_11_47_3.png

  10. On the Find latest products page, click Execute to check for installer updates from MySQL. If you want to use the version you have, you can select the skip option. When checking is complete, click Next.

    images/download/attachments/6046023/image2015-2-23_11_47_42.png

  11. On the Choosing a Setup Type page, the simplest option is to select Developer Default and click Next. The only drawback is that the install will be much larger.

    images/download/attachments/6046023/image2015-2-23_11-48-21.png

    Optionally, you can select the Custom option and remove everything except the MySQL Server object. You can include the MySQL Workbench if you want, it is nice to have if you ever want to modify the raw structures

    images/download/attachments/6046023/Capture.PNG

  12. On the Check Requirements page, click Execute to make sure all required prerequisites are met. Follow any instructions to install any missing prerequisites. Click Next once all prerequisites are met.

    images/download/attachments/6046023/image2015-2-23_11_51_37.png

  13. On the Installation Progress page, click Execute to install all of MySQL products.
    The MySQL Server and the MySQL Workbench will both be installed. Once all of the products are installed click Next.

    images/download/attachments/6046023/image2015-2-23_11_52_15.png

  14. On the Configuration Overview page, click Next to setup the configuration.

  15. On the MySQL Server Configuration page (1/3), make sure the default Port Number is 3306, keep all the defaults and click Next.

    images/download/attachments/6046023/image2015-2-23_11_52_57.png

  16. On the next MySQL Server Configuration page (2/3), choose a password for the root user, type it in, and write it down so you have it for future, then click Next.

    images/download/attachments/6046023/image2015-2-23_11_53_41.png

  17. Make sure the following two items are selected by default:
    Start the MySQL Server at System Startup
    Standard System Account

    images/download/attachments/6046023/image2015-2-23_11_54_39.png

    This installs MySQL as a Service and starts MySQL automatically each time you start your computer.

  18. Click Next. The Configuration Overview page is displayed and shows the MySQL server installation is complete.

    images/download/attachments/6046023/image2015-2-23_12_3_34.png

  19. Click Next.

  20. The Installation Complete window is displayed and shows the check box for Start MySQL Workbench after Setup is selected.

    images/download/attachments/6046023/image2015-2-23_12_10_42.png

  21. Click Finish to close the Wizard and complete the installation.

    The MySQL Workbench window is displayed. MySQL Workbench lets you to administrate the MySQL server.

  22. Click on Local instance MySQL to connect to the newly installed MySQL server.

    images/download/attachments/6046023/image2015-2-23_12_13_25.png

  23. Enter the root password you earlier entered into the installer and click OK.

  24. The Local instance MySQL graphical user interface is displayed.

    images/download/attachments/6046023/image2015-2-23_12_14_11.png

    You are now connected and can see, in the Navigator, the default databases. Older versions of MySQL will start with a database named test where new ones may not.

  25. If you want to create a new schema with a new name (like test), right-click in the white background of the Object Browser (next to the rest of the schemas) and select Create Schema. Name it and click the Apply button in the lower right.