MySQL Workbench offers three editions:
- Community Edition: it is the open-source edition of MySQL Workbench, that is available for free
- Standard Edition: It is an edition with high performance, industrial strength, and scalable OLTP apps
- Commercial Edition: This edition comes with high security and advanced features along with technical support for managing MySQL tasks and applications
In this guide, you will get a step-by-step guide for installing your MySQL Workbench in Windows.
MySQL Workbench Installation
Go to the download page of MySQL Workbench, Select your operating system as Windows, choose the architecture as per your system, and click on the “Download” button:
Click on “No thanks, just start my download”, to begin the download:
Once the download is complete, go to the folder where it is downloaded:
Open the installer and click on the “Next” button:
Browse for the location where you want to install it and click on the “Next” button:
Choose “Complete” to ensure that all program features get installed and click on the “Next” button:
Click on the “Install” button:
Wait until the installation process is in the progress:
Once the setup is finished click on “Finish”, and select the option “Launch MySQL Workbench now”:
MySQL Workbench will open successfully after its installation:
Create a New Database Connection in MySQL Workbench
To create a new connection, click on the “Database” and select “Manage connections” from the list:
To create a new database connection click on the “New” button:
Provide the “Connection Name”, and “Username” and for setting the password click on the button “Store in Vault”:
A new wizard will open, set a password and click on “OK”:
Click on the “Close” button:
A new database was created successfully, and now you can connect it to your MySQL Workbench.
In the MySQL Workbench Home Screen, open the “Database” list and click on the option “Connect to Database”:
Select the database that you created as “Stored Connection”, provide the Username of that database, and click on “OK”:
Enter the password of the username of the database you want to connect to and click on the “OK” button :
It will connect the database if provided parameters are correct:
It is visible that the Database is connected successfully.
Conclusion
MySQL workbench can be installed on windows by downloading it from the MySQL website. Once the download is complete, open the installer and browse for the location to install it, choose the setup type as “Complete” to ensure that all the features get installed, click on the “Install” button, and wait for it to install. To create a new database, select the “Manage connections” option and provide the required parameters. You can even connect to the newly created database by clicking on “Connect to Database” and providing the details of the existing database.
