Step 1
Go to https://dev.mysql.com/downloads/installer/ and download Windows (x86, 32-bit), MSI Installer [ 422 MB size ]
🚀 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
click on next
Step 4
Product Configuration
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
here too click on next
Step 5
Set password for root user
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
Again click on Next
Click on Execute [ this will take time to apply configuration ]
Click on Finish
Again click on Next ( It will ask for configuration again ignore and click on Next )
click on Finish
Click on next till following window appears
Enter Password you created in previous steps and click on Check
Click on Next
Click on Execute
Click on Finish
On next window it will ask for configuration again just click on next
Click on Finish
You have successfully installed MySQL and MySQL workbench on windows.
Step 6
To verify successful installation
open MySQL Workbench
click on Local instance
Enter password created during setup
Enter query " show databases; " and click on lightning symbol to execute it
If you get this output like this, Yes you have installed MySQL and MySQL workbench completely!
Happy Programming!
Top comments (0)