SQL -Structured Query Language - Overview - How To Download And Install MySql Workbench Tutorial
To install MySQL Workbench, follow these steps:
Prerequisite - Xampp or Wamp Server
Check this blog to install XAMPP Server on Windows.
Step 1: Download Mysql Workbench from https://dev.mysql.com/downloads/workbench/ and click on the download
Step 2: On the next page, click on "No thanks, just start my download".
Step 3: Once the download is complete, open the .exe file of Mysql Workbench and click on next to continue
Step 4: Keep Install Location as by default or change it, if you want.
Step 5: Choose the Setup type as Complete.
Step 6: Now click on Install.
Step 7: Then your installation will start and click on the finish after installation
Hence MySQL Workbench is successfully installed.
Running First SQL Query in MySQL Workbench
Step 1: Open the MySQL Workbench from the window search bar. It will look like this
Step 2: First Switch-On (Start) the Apache and Mysql from the xampp or wamp server.
Then Click on rescan servers. It will detect Mysql ( port - 3306 ) that are already started in the xampp or wamp server.
Step 3: After Scanning it will show the MySQL Connections.
Step 4: Then it will show a warning, click on Continue Anyway.
Step 5: Dashboard will be opened.
Open a query editor mark on the left side and write the first query to create a database such as “create database employees” and click on execute (power symbol)
It will create a database of employees.
If the output shows a green mark then it is executed successfully.
If it still not showing click on refresh, marked in an image.
Congratulation, You successfully execute your first SQL Query.