DEV Community

loading...
Cover image for Step by step installation of MySQL Workbench on windows 10

Step by step installation of MySQL Workbench on windows 10

yunweneric profile image Erickeyz Updated on ・3 min read

Introduction

What is MySQL?

MySQL is an open-source relational database management system (RDBMS).Its name is a combination of "My", the name of co-founder Michael Widenius's daughter, and "SQL", the abbreviation for Structured Query Language. A relational database organizes data into one or more data tables in which data types may be related to each other; these relations help structure the data. SQL is a language programmers use to create, modify and extract data from the relational database, as well as control user access to the database. MySQL is used by several developers and tech companies such as facebook, github, netflix, youtube, ebay, paypal, linkedIn, etc.

What is MySQL Workbench?

MySQL Workbench is a visual database design tool that integrates SQL development, administration, database design, creation and maintenance into a single integrated development environment for the MySQL database system.

Requirements

  1. A Pc with windows 10 properly installed with; Microsoft .NET Framework 4.5.2, Microsoft Visual C++ Redistributable for Visual Studio 2019 and Microsoft Windows 10 or Windows Server 2019

Alt Text

  1. Stable Internet Connection

Alt Text

Procedure

Step 1: Download MySQL Workbench

Go to the official MySQL Workbench page and download it. You can easily do that by Clicking here

Alt Text

Step 2: Locate file and Run Installation

GO to your download folder or wherever the file has downloaded in your pc and double click on the file or right click on the downloaded file then choose install
Alt Text

Step 3: Next

Click on the next button to proceed with the installation

Alt Text

Step 4: Select installation Directory

Choose the folder you want to install MySQL Workbench. Usually, it is advised to leave the default installation path chosen by your system. When you are done, click next.

Alt Text

Step 5: Select the type of installation:

In this step the type of installation you want. By default the complete installation is chosen by the system. But if you are an advanced user and know how to walk your way by the custom installation, then choose the custom install. It is recommended to select the complete installation.

Alt Text

Step6: Review for final Installation:

In this final step, review your installation steps. If there is anything you see not proper, the go back and adjust it else you wont be able to do so. So far so good, everything is okay. Click on install to proceed.

Alt Text

Step 6: Wait

Take a seat and wait for the installation process to run to completion.

Alt Text

Step 7: Done

Once this is done, click on finish to proceed. uncheck the box to the extreme bottom left if you don't want to run MySQL Workbench immediately. I'd prefer you run it instantly to see if it was properly installed.

Alt Text

Step 8: Test

If everything went well then congrats you did it. You should see a window open up that looks like this.

Alt Text

Conclusion:

Congratulations you did it. If you faced any difficulties in this post, Please do well to comment and share your feedbacks. Thanks

Alt Text

Discussion (0)

pic
Editor guide