DEV Community

Cover image for How Install MySQL and Workbench on Windows
G Sudarshan
G Sudarshan

Posted on

How Install MySQL and Workbench on Windows

Step 1

Go to https://dev.mysql.com/downloads/installer/ and download Windows (x86, 32-bit), MSI Installer [ 422 MB size ]

Image description

🚀 On next page website will ask to login just click on "No Thanks, Just Start my download"

Step 2

Execute the downloaded file.

You will be asked to choose a setup

Select Developer Setup, click on next

then some things like Extension for VSCode or if Python is not installed on your PC installer will ask you to download and install it manually but you can ignore that as they are not essential ( unless you are going to use python itself for development )

Step 3

The Installation

All products to be installed will be listed

click on execute to install all of them

Image description

Image description

click on next

Step 4

Product Configuration

Image description

click on next

ports will be available to configure in most of the cases leave it as it is, But if you need to change ports due to clashes between different services with same you probably understand what you are doing so I don't need to elaborate that here.

If you don't know what to do or feeling confused just click on next

Image description

here too click on next

Step 5

Set password for root user

Image description

you can also add other users here but if you are installing it first time you probably using it for learning purpose hence you don't need it, don't worry you can create users later too.

Click on Next

Image description

Again click on Next

Image description

Click on Execute [ this will take time to apply configuration ]

Image description

Click on Finish

Again click on Next ( It will ask for configuration again ignore and click on Next )

Image description

click on Finish

Click on next till following window appears

Image description

Enter Password you created in previous steps and click on Check

Image description

Click on Next

Image description

Click on Execute

Image description

Click on Finish

On next window it will ask for configuration again just click on next

Image description

Click on Finish

You have successfully installed MySQL and MySQL workbench on windows.

Step 6

To verify successful installation

open MySQL Workbench

Image description

click on Local instance

Enter password created during setup

Image description

Enter query " show databases; " and click on lightning symbol to execute it

Image description

If you get this output like this, Yes you have installed MySQL and MySQL workbench completely!

Happy Programming!


🐦 @g_sudarshan11 Twitter

🐧 G-Sudarshan GitHub

🏒 g-sudarshan LinkedIn

📸 @g_sudarshan11

Discussion (0)