DEV Community

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

Posted on

5 1 1

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

Image of AssemblyAI tool

Transforming Interviews into Publishable Stories with AssemblyAI

Insightview is a modern web application that streamlines the interview workflow for journalists. By leveraging AssemblyAI's LeMUR and Universal-2 technology, it transforms raw interview recordings into structured, actionable content, dramatically reducing the time from recording to publication.

Key Features:
🎥 Audio/video file upload with real-time preview
🗣️ Advanced transcription with speaker identification
⭐ Automatic highlight extraction of key moments
✍️ AI-powered article draft generation
📤 Export interview's subtitles in VTT format

Read full post

Top comments (0)

Billboard image

Try REST API Generation for MS SQL Server.

DreamFactory generates live REST APIs from database schemas with standardized endpoints for tables, views, and procedures in OpenAPI format. We support on-prem deployment with firewall security and include RBAC for secure, granular security controls.

See more!

👋 Kindness is contagious

Explore a sea of insights with this enlightening post, highly esteemed within the nurturing DEV Community. Coders of all stripes are invited to participate and contribute to our shared knowledge.

Expressing gratitude with a simple "thank you" can make a big impact. Leave your thanks in the comments!

On DEV, exchanging ideas smooths our way and strengthens our community bonds. Found this useful? A quick note of thanks to the author can mean a lot.

Okay