My SQL Workbench Installation and Connecting to My SQL Server

After getting the proper knowledge of the basic SQL terms from our previous blog, let's process further. In this article, we will cover the My SQL Workbench installation process in the system. This article will help you to install My SQL Workbench with its server setup in your system. This step-by-step process will be very easy to perform.

Table of Content

My SQL Workbench Installation Process

Step-1 Move to any of the browsers and search for “MySQL”. 

Step 1.webp

Step-2 Click on link with domain name “” and move to its “Download Page”. 

Click on link with domain name and and move to its & Download Page

Step-3 Scroll Down to the bottom and click on “MySQL Community (GPL) Downloads »” link. 

Scroll Down to the bottom and click on MySQL Community (GPL) Downloads link.

Step-4 Click on the "My SQL Installer for Windows" link.

Click on the My SQL Installer for Windows link

Step-5 Choose the First Installer and click on the "Download" button.

Step 5.webp

Step-6 Click on the "No thanks, just start my download" link.

Step 6.webp

Step-7 Once the file is downloaded, open the folder and start the installation. Choose the “Next” button in the opened dialog pop-up.

Step 7.webp

Step-8 Select the “Custom” option and click on the Next button. 

Step 8.webp

Step-9 Now expand the columns for “MySQL Servers” and choose the top version server under “MySQL Server” (i.e., MySQL Server 8.0 ) and click on the Right Arrow seen for moving the selected server to the right. 

Step 9.webp

Step-10 Now select the latest servers for the “Applications "and “MySQL Shell” as well and click on the “Next” button. 

Step 10.webp

Step-11 Click on the “Execute” button and wait for the installation to get started. 

Step 11.webp

Step-12 Wait till the installations get completed and keep clicking on the “Next” button. 

Step 12.webp

Step-13 Now the installation process will ask you to set the “Root Password” for the user and you can even add a new user if you want to.  Note: Please remember the password or note it somewhere securely. 

Step-14 Click on the “Execute” button on the Apply Configuration window.

Now the installation process will ask you to set the Root Password for the user,

Step-15 Click on the “Finish” button.

Click on the Execute button on the Apply Configuration window.

Step-16 Click the “Finish” to the Installation Completed dialog box. 

Click on the Finish button.

Step-17 The Workbench will automatically get launched and then you can start working on it. 


Connecting to MySQL server:

Before starting the work in My SQL Workbench, we need to set up the SQL Server. So, follow the steps one by one, mentioned below:

Step-1 Open your Command Prompt from the Window.

Step 1 (1).webp

Step-2 Now enter the command “cd (The full path of your SQL bin folder location) “and hit ENTER button. (e.g. - cd C:\Program Files\MySQL\MySQL Server 8.0\bin). 


Step 2.webp



Step-3 Now type "mysql -u root -p" and hit ENTER. It will ask you for the password. Enter the root user password and hit the Enter button. After this process, the command prompt is converted with "MySQL" text.  

Step 3.webp

Step- 4 Now start MySQL Workbench 8.0 and choose the local host user and enter the password of the Root User.

Now start MySQL Workbench 8.0

Step-5 Now click on the "Startup/Shutdown" category seen under the "Instance" module within the "Navigator" panel and check the server status as Running. 

Now click on the Startup/Shutdown" category

Step-6 The setup is done, and our SQL server is running. Now, you can start running queries in the provided work area. 



Installing SQL in the system is relatively easy, but it requires some expertise to configure it properly. Following our expert's step-by-step SQL installation guide, you can perform the task accurately.

So, after successfully installing MySQL Workbench in your system, you are ready to move forward, that is, executing the daily used SQL Queries. We will have a bunch of queries that will be useful in our daily development or testing work.

Author Bio

Kevin Patel.pngBhargav Padalia started his career in the QA field two years back. He got his first certification in manual testing; he has claimed the title of the rising star. Currently, he is working as a QA executive in a software testing company.

In his leisure time, he loves watching detective movies and learning new things that make him more proficient in his career.