How Install MySQL and Workbench on Windows
Tags: mysql, windows, sql, installation
Published: 2022-05-04 13:49:12



### Step 1

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


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/8iqngco4ywrrugcndwu7.png)

 

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

</aside>

### 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](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/cix79cdixbv7n2crilqc.png)


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/85pqo1rbd8kmseddhxrw.png)

click on next

### Step 4

Product Configuration


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/wzeht51aqa0658o0ai4k.png)

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](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/swrjl0i7pnfiiwk5eler.png)

here too click on next

### Step 5

Set password for root user


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/mv56yue9ek3mp5smjwe6.png)

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](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/2vdtu2izckllj6ci5zx0.png)

Again click on Next


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/0ox15d6aat8pu3183k6n.png)

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


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/tp350f3hbd2tf8if71r8.png)

Click on Finish

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


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/4mhtg8unlpi2vlwkrk6w.png)

click on Finish

Click on next till following window appears


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/baz4p3hcaoc2fvtvd9x5.png)

Enter Password you created in previous steps and click on Check


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ij5qsk2j6wmzsuhnpsp3.png)

Click on Next

 


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/h3u5rheym4hof00hs9fi.png)

Click on Execute


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/8ahrqqmhakbxkw8n4hdc.png)

Click on Finish

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


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/0r4iqj9iekd16iypm8lk.png)

Click on Finish

You have successfully installed MySQL and MySQL workbench on windows.  

### Step 6

To verify successful installation 

open MySQL Workbench


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/dlis0zsmak49lhekyd0p.png)

click on Local instance

Enter password created during setup


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/jriljrk98g5tlb1ii5uq.png)

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


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/99aycw9xw68jj5jz0y0t.png)

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

Happy Programming!

---

🐦 [@g_sudarshan11 Twitter](https://twitter.com/g_sudarshan11)

🐧 [G-Sudarshan GitHub](https://github.com/G-Sudarshan)

🏒 [g-sudarshan LinkedIn](https://www.linkedin.com/in/g-sudarshan/)

📸 [@g_sudarshan11](https://instagram.com/g_sudarshan11)