Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Installing MySQL on Windows: A Step-by-Step Guide with Screenshots, Exercises of Java Programming

A detailed, step-by-step guide on how to install and configure the MySQL database on a Windows system, complete with screenshots. The process includes downloading MySQL, executing the installer, setting up authentication methods, and connecting to the database using various tools.

What you will learn

  • What tools can be used to connect to the MySQL database after installation?
  • What is the role of the MySQL Command Line Client in the installation process?
  • What is the first step to install MySQL on Windows?
  • How do you configure the MySQL database in Windows?
  • What is the purpose of the MySQL Shell and how is it used?

Typology: Exercises

2021/2022

Uploaded on 11/15/2022

mitali-gadhiya
mitali-gadhiya 🇮🇳

5

(1)

5 documents

1 / 14

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
MITALI GADHIYA 186250307015
1
PRACTICAL: 1
INSTALL MySQL ON WINDOWS
Install and configure MySQL database in Windows. Explain all the
steps with particular screenshots.
Download MySQL on https://dev.mysql.com/downloads/installer/.
Then open MySQL set up.
click run.
wait for few second.
after installation complete then click next.
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe

Partial preview of the text

Download Installing MySQL on Windows: A Step-by-Step Guide with Screenshots and more Exercises Java Programming in PDF only on Docsity!

PRACTICAL: 1

INSTALL MySQL ON WINDOWS

  • Install and configure MySQL database in Windows. Explain all the

steps with particular screenshots.

▪ Download MySQL on https://dev.mysql.com/downloads/installer/. ▪ Then open MySQL set up. ▪ click run. ▪ wait for few second. ▪ after installation complete then click next.

▪ click next. ▪ click next.

▪ click next. ▪ click next.

▪ Read Authentication method then click next. ▪ Enter password. ▪ Again re-enter password. then click next.

▪ when installation completed. ▪ Then click finish. ▪ Click next.

▪ If you test connection then enter Hostname and password. ▪ Click test connection. Then click finish. ▪ Click next.

▪ Click execute and wait for few minute. ▪ Configuration operation completed.Then click finish.

▪ Click next. ▪ Here installation completed. Then Click finish.

▪ Write command : \connect root@localhost:3306. ▪ And enter password.

  • Open MySQL workbench ▪ Click database ▪ Then click connect to database.

▪ Click store it vault. ▪ And enter password. ▪ Then click ok.