EDUCBA

EDUCBA

MENUMENU
  • Blog
  • Free Courses
  • All Courses
  • All in One Bundle
  • Login
Home Data Science Data Science Tutorials MySQL Tutorial Install MySQL

Install MySQL

By Priya PedamkarPriya Pedamkar

How To Install MySQL

How to Install MySQL on Windows?

The following article presents instructions for installing MySQL, an open-source relational database system that stores and manages data. Michael Widenius and his team developed it, and Oracle Corporation maintains it. Businesses and individuals across the world widely use MySQL.

Steps To Install MySQL on Windows (Guide)

The steps to install MySQL are as follows:

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

Step 1: To download and install MySQL on your local system, visit: https://dev.mysql.com/downloads/. Once the page opens, click on ‘MySQL Community Server.’

MySQL Community Server

 

Step 2: On the next page, under the ‘Generally Available(GA) Releases’ section, select the ‘Operating System‘ from the dropdown menu. Microsoft Windows will always be the default option.

Generally Available(GA) Releases

 

Step 3: Scroll down and click ‘Go to Download Page,’ as highlighted in the image below. Please do not download from the ‘Other Downloads’ section that is available below.

Go to Download Page

Step 4: It will redirect to another page, and one must click on the second option, i.e., Windows (X86, 32-bit) and MSI Installer (437.3 MB). The first option (2.4 MB) should be avoided, as it is a web-based installer.

redirect to another page

Step 5: It will again redirect to another page with three options.

  1. One can click on Login’ if one has an Oracle account.’
  2. Alternatively, one can click the ‘Sign Up’ option and fill in the necessary details.
  3. Below both, a third option will allow downloading without any registration. Click on ‘No thanks, just start my download,’ and the downloading process will resume soon.

Mysql Install output 5

Step 6: Once the download is complete, click on the file. A pop-up will appear, and one must click ‘Yes’ to begin the installation process.

Mysql Install output 6

Step 7: The installer will present the ‘License Agreement.’ Tick the ‘I accept the license terms’ box and proceed by clicking on ‘Next.’

Mysql Install output 7

Step 8: Select the ‘Developer Default’ option and click the ‘Next’ button, as shown below.

Mysql Install output 8

Step 9: Click the Next button in the ‘Check Requirements’ window.

Mysql Install output 9

Step 10: A warning message will appear, but one must click ‘Yes’ and proceed.

Mysql Install output 10

Step 11: Now click on the ‘Execute’ button.

Mysql Install output 11

Step 12: Executing all of the above products will take some time. Keep checking the status, and once completed, click on the ‘Next’ button.

Mysql Install output 12

Step 13: Click ‘Next’ in the ‘Product Configuration’ window again.

Mysql Install output 13

Step 14: In the Group Replication window, click on the ‘Standalone MySQL Server/Classic MySQL Replication.’ Proceed to click on the ‘Next’ button.

Mysql Install output 14

Step 15: Click ‘Next’ in the ‘Type and Networking’ window. Do not make any changes therein.

Mysql Install output 15

Step 16: In the ‘Authentication Method’ window, select the ‘Use Strong Password Encryption for Authentication’ option and proceed to click on the ‘Next’ button.

Mysql Install output 16

Step 17: Next, type the ‘MySQL Root Password’ and repeat it. The password will be required when opening MySQL. Click on the ‘Next’ button after that.

output 17

Step 18: Again, click on the ‘Next’ button.

output 18

Step 19: The ‘Apply Configuration’ window will appear. Click on the ‘Execute’ button.

output 19

Step 20: Now, click on the ‘Finish’ button.

output 20

Step 21: The ‘Product Configuration’ page will appear. Click on the ‘Next’ button.

output 21

Step 22: In the next window, keep the ‘User name’ as “root” by default. Type the ‘Password’ which you had set earlier. When clicked on ‘Check,’ it will test whether the server is connected and whether the installation has been completed successfully. Proceed to click on ‘Next.’

output 22

Step 23: Some systems require more steps to configure other installations supporting MySQL. In that case, click on the ‘Next’ and ‘Execute’ buttons; to avoid making any changes. Some systems will automatically configure settings. Finally, click on the ‘Finish’ button.

output 23

Step 24: The MYSQL shell and MySQL Workbench will open once the installation is complete. Please close both and restart your system.

output 24

Step 25: Go to the ‘Start’ menu and search for ‘MySQL.’ Multiple files related to MySQL will appear but look for only ‘MY SQL Command Line Client‘ and ‘MySQL Workbench.’ Both options have their respective versions (in the image below, it is 8.0). It may differ from user to user and version to version, but the steps would be the same. Click on ‘MY SQL Command Line Client’ shown below:

output 25

Step 26: It will initiate the ‘MySQL Command Prompt’ and ask for the ‘Root Password’ (entered during the installation). Type the password and press ‘enter.’ After authentication, it will start with ‘mysql>‘ as shown below.

output 26

Step 27: Check whether MySQL works and how many databases it contains.

Upon typing the ‘show databases’ command:

  • It will show all available databases in MySQL, as displayed below. This indicates everything is working fine.
  • It will show, here, that it has six databases available, i.e., information_Schema, mysql.

output 27

Step 28: To close MySQL, please type the ‘exit’ command, as shown below.

output 28

Recommended Articles

We hope that this EDUCBA information on “Install MySQL” was beneficial to you. You can view EDUCBA’s recommended articles for more information.

  1. MySQL Numeric
  2. MySQL JSON Data Type
  3. Community Server MySQL
  4. MySQL IF EXISTS
C++ PROGRAMMING Certification Course
38+ Hours of HD Videos
9 Courses
5 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
ASP.NET Certification Course
149+ Hours of HD Videos
28 Courses
5 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
SQL - Everything in SQL
253+ Hours of HD Videos
51 Courses
6 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
SOFTWARE TESTING Certification Course
74+ Hour of HD Videos
13 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
Primary Sidebar
Popular Course in this category
MYSQL Certification Course
 115+ Hours of HD Videos
18 Courses
3 Mock Tests & Quizzes
  Verifiable Certificate of Completion
  Lifetime Access
4.5
Price

View Course
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more