How to install MySQL 8 for development in Windows

Posted on July 5th 2018 by Zarko

How to install MySQL 8 for development in Windows

MySQL Logo

Visit the MySQL Community Server download page by clicking on the following link: https://dev.mysql.com/downloads/mysql/

Scroll down the page and make sure 'Microsoft Windows' option is selected as your operating system, then click 'Go to Download Page' for the Windows (x86, 32 & 64-bit) MySQL Installer MSI.

MySQL Windows Download Page

Scroll down the page again, to where you can pick the web installer (online installation) or an offline installer (downloads the full installer which does not require a connection). We will chose the offline installer option, as shown on the screenshot below.

MySQL Windows Download Page

This will finally take you to the download page, where you will be prompted to log in or sign up with Oracle Web. This is not required to download the MySQL installer, so you can just scroll to the bottom and select the 'No thanks, just start my download.' option

MySQL Windows Download Page

After the download finishes, run the MySQL .msi installation file (press 'Run'/'Yes' when the Window security dialog pops up)

1) Tick the 'I accept the license terms' checkbox (after reading the license agreement carefully) and then press 'Next'

MySQL Windows Installation

2) Select the 'Developer Default' option and click 'Next' (You can check the 'Setup Type Description' on the right to see what will get installed)

MySQL Windows Installation

3) Click the 'Execute' button to install the requirements - follow each of the requirements installers through until it's all done. There may be some requirements that need a manual installation, which can be done by following the 'Download URL'. In this example, if you won't be connecting your MySQL to Python you can skip it's manual installation.

Click 'Next' to continue with the installation. Press 'Yes' if a dialog about the missing requirements which we chose not to install pops up.

MySQL Windows Installation

4) Click 'Execute' to install all the products that come with the MySQL Installer. Wait for the installations to complete before clicking 'Next' to head to the next step.

MySQL Windows Installation

5) Click 'Next' to begin the MySQL configuration process.

MySQL Windows Installation

6) Leave the 'Standalone MySQL Server / Classic MySQL Replication selected and press 'Next'.

MySQL Windows Installation

7) Leave the 'Development Computer' option selected, and click 'Next'.

MySQL Windows Installation

8) In this step, we can select the new, strong password encryption method for authentication. Press 'Next' to proceed.

MySQL Windows Installation

9) Type in a password for your root account. Make sure that you remember your password (to make your password strong, use a combination of lowercase and uppercase letters, numbers and symbols). After setting the password, click the 'Add User' button.

MySQL Windows Installation

Type your name in the 'Username' field, and set the 'Password' for your personal account (it can be the same as your root password, just keep them safe!), then press 'OK' to finish.

Lastly, press 'Next' to finish this step.

MySQL Windows Installation

10) Leave the selected options and click the 'Next' button.

MySQL Windows Installation

11) Again, you don't have to change anything, just press 'Next'.

MySQL Windows Installation

12) Finally, press 'Execute' to apply the settings and then 'Finish' to finalize the server configuration.

MySQL Windows Installation

13) Leave the default settings for other products and keep pressing 'Next'.

[OPTIONAL] When you reach the 'Connect To Server' window you can type the credentials you created in the user and password fields. Click 'Next' after entering your data.

MySQL Windows Installation

14) After that, keep pressing 'Next' and you should reach the 'Installation Complete' window, at last! Press the 'Execute' and then 'Finish' to finalize the installation.

MySQL Windows Installation

Starting the MySQL Command Line Client

Press the Windows Start button and find MySQL 8.0 Command Line Client under your programs list (or type 'mysql command line client' while in the Start menu to find the shortcut).

Enter your root password and you will have access to the MySQL console!

MySQL 8.0 Command Line Client

And that's finally it!