logo

MySQL Installation Guide

MySQL Community Edition
  • Freely downloadable version of the MySQL.
  • Available on over 20 platforms and operating systems including Linux, Unix, Mac and Windows.
  • The latest version is MySQL Community Server 5.6.23 (March 11,2015)

  • This guide is prepared for Windows platform. You can adapt the steps according to your platform.

    How to Install MySQL Community Edition?

    Type "mysql community server" keyword into the query box on a search engine page (such as Google), then press ENTER. After searching, click on the first link.


    Search


    In the opening page select your platform for MySQL Community Server 5.6.23, and click on "Download" button.
    You have one more thing to take into consideration: version of the operation system (32-bit vs. 64-bit model)


    Version


    Click on the second "Download". Download mysql-installer-community-5.6.23.0.msi which have bigger size.


    Download


    In the opening page click on the link "No thanks, just start my download" Start


    You have downloaded the .msi file. Double click on it.


    License agreement. Click on "Next" button.


    Next


    Choose a Setup Type. You can choose any of them but "Full" is recommended. "Full" installs all of the products available in this catalog including MySQL Server, MySQL Workbench, MySQL Connectors, documentation, samples and examples and much more. Click on "Next" button.


    Full


    Installer try to resolve some requirements. If the requirements are fulfilled, then the installer starts the installation automatically. Otherwise, you have to resolve the failing requirements manually. Click on the "Execute" button.


    Check


    License agreement... Click on "Install" button.


    License


    If you encounter the popup window like below, click on the "Repair" button.


    Modify


    Then, you will have the popup window like below. Click on the "Close" button.


    Close


    You have met the two requirements MySQL Workbench 6.2.4 and MySQL Fabric 1.5.3 & MySQL Utilities 1.5.3 with the help of the installer. Two


    The two requirements "MySQL for Visual Studio 1.2.3" and "Connector/ Python (3.4) 2.0.3" are not fulfilled. So you have to install them manually. Type "free visual studio download" keyword into the query box on a search engine page (such as Google), then press ENTER. After searching, click on the first link.


    Search


    In the opening page click on "Free Visual Studio" button.


    Version


    Click on "Download" button for "Visual Studio". Visual Studio is a feature rich development environment for creating applications across devices, desktops, web and the cloud.


    Version


    You have downloaded the vs_community.exe file. Double click on it. The setup process is started. Agree to license terms and click on "Next" button.


    Version


    There are optional features to install... Click on "Install" button to install to defaults. This process will take some time.


    Version


    Visual Studio setup is completed!

    Version


    Yo need to check whether you fulfilled the missing requirements or not. Let's return the MySQL Installer. There is only one failing requirement "Connector/ Python (3.4) 2.0.3"


    Version


    To download Python 3.4, go to URL given https://www.python.org/download/ Download the latest version for your operating system. For Windows users, click on Download Python 3.4.3


    Version


    Python 3.4.3 Setup window is opened. Select the installation choice and click on Next


    Version


    Select destination directory for setup.


    Version


    You can customize your setup by changing the way features will be installed.


    Version


    The setup is completed. Click on Finish


    Version


    Check the situation of the requirement in MySQL Installer. If you encounter a screen like below, you are at the right way. Click on Next button.


    Version


    Click Execute to install/ update some packages.


    Version


    As components are installed, their Status changes from a progress percentage to "Complete".


    Version


    After all components are installed, the next step configures some of the recently installed MySQL products.


    Version


    Choose the MySQL server configuration type that describes your setup. This setting defines the amount of system resources that will be assigned to your MySQL server instance. You do not need to consider about what those options exactly are. You can continue with default options. If you want to learn details, you can read this guide: http://dev.mysql.com/doc/mysql-installer/en/mysql-installer-gui.html Checking the "Advanced Configuration" option provides additional Logging Options to configure, so I checked it. (optional)


    Version


    Next, define your MySQL account information. Assigning a root password is required. Optionally, you can add additional MySQL user accounts with predefined user roles.


    Version


    Next, configure the Windows Service details. This includes the service name, whether the MySQL Server should be loaded at startup, and how the Windows Service for MySQL Server is executed.


    Version


    The next configuration step is available if the "Advanced Configuration option" was checked. This section includes options that are related to the MySQL log files. Click Next to continue on to the final page before all of the requested changes are applied.


    Version


    This Apply Server Configuration page details the configuration steps that will be performed. Click Execute to execute the configuration steps. The icon for each step toggles from white to green on success, or the process stops on failure. Click the Log tab to view the log. After the MySQL Installer configuration process is finished, MySQL Installer reloads the opening page where you can execute other installation and configuration related actions. MySQL Installer is added to the Microsoft Windows Start menu under the MySQL group. Click on Finish.


    Version


    Opening MySQL Installer loads product configuration. Click on Next.


    Version


    You can check user and password field to have a successful connection. Then, click on Next.


    Version


    Apply server configuration. Click on Execute. The icon for each step toggles from white to green on success, or the process stops on failure. Click on Finish.


    Version


    The installation process is completed. Check the "Start MySQL Workbench after setup" option to start the workbench. Click on Finish.


    Version