Scribd
Upload
12 views

Install SQL Workbench for MySQL on Windows

This document provides a step-by-step guide for downloading and installing MySQL and MySQL Workbench on Windows. It includes instructions for setting up a new connection in MySQL Workbench and executing a basic SQL query. The guide emphasizes the importance of password security when accessing the database.

Uploaded by

venkat1238c
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
12 views

Install SQL Workbench for MySQL on Windows

This document provides a step-by-step guide for downloading and installing MySQL and MySQL Workbench on Windows. It includes instructions for setting up a new connection in MySQL Workbench and executing a basic SQL query. The guide emphasizes the importance of password security when accessing the database.

Uploaded by

venkat1238c
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 26

Step 1: Browse to the official MySQL Website.

Step 2: There you will find the Download button.

Step 3: Scroll down & click on MySQL Community (GPL) Downloads.

Step 4: Click on MySQL Installer For Windows.


Step 5: Click on the first Download Link.

Step 6: Then click, No Thanks, Just Start My Download.


Step 7: Click on the Custom button.

Step 8: Expand MySQL Server & then expand MySQL Server 8.0.
Step 9: Then double click on the latest version & click on the drag button.
Step 10: Then expand Applications & Then expand MySQL Workbench 8.0
Step 11: Then double click on the latest version & click on the drag button.
Step 12: Then expand MySQL Shell & then expand MySQL Shell 8.0
Step 13: Then double click on the latest version & click on the drag button.
Step 14: Click on Next.
Step 15: Click on Execute.
Step 16: Click on Next.
Step 17: Click on Execute.
Step 18: Click on Next.
Step 19: Click on Next.

Step 20: Click on Next


Step 21: Click on Next.
Step 22: Set your Password & Click on Next.
Step 23: Click on Next.
Step 24: Click on Execute.
Step 25: Click on Finish.
Step 26: Click on Next.
Step 27: Click on Finish.
Step 28: Then Automatically MySQL Workbench Window will open.
Click on the “plus sign” next to MySQL Connections to create a new
connection.

4) At the “Setup New Connection” dialog, fill in the information as follows:

Connection Name: mis2502

Hostname: dataanalytics.temple.edu

Username: Your username given to you by your instructor

Set password in Store in Vault


Click “OK” and you’ll see the connection under “MySQL Connections”:

6) It will ask you for your password. Enter your password (it’s case sensitive)
and click OK. (If you’re in a lab, don’t save your password in the vault or
other people will be able to access your account!)

7) You’ll see the main window for MySQL Workbench:

Quick Guide to MySQL Workbench


All you really care about is the Query 1 tab on the right and the SCHEMAS
section on the left.

8) Try a query. In the SQL File 1 window, type: SELECT * FROM moviedb.actor;

Then click the lightning bolt to execute the query:


Quick Guide to MySQL Workbench

You’ve successfully run your first query!

You might also like