MySQL Installation
Start course
Difficulty
Beginner
Duration
2h 34m
Students
238
Ratings
3.6/5
starstarstarstar-halfstar-border
Description

In this course, we will learn the concepts of microservice and spring framework with a focus on Spring Boot.

Learning Objectives

  • Understanding Spring Boot

Intended Audience

  • Beginner Java developers
  • Java developers interested in learning how to Build and Deploy RESTful Web Services
  • Java Developers who want to develop web applications using the Spring framework
  • Java Developers who want to develop web applications with microservices
  • Java Developers who wish to develop Spring Boot Microservices with Spring Cloud

Prerequisites

  • Basic Java knowledge
Transcript

Hello, dear friends. In this video, we will install the MySQL server and MySQL server bench on the Windows 10 operating system. Let's begin. First, open any browser and search for MySQL on Google. Go to the MySQL website. Click the 'Downloads' tab. Click 'MySQL Community (GPL) Downloads.' Click 'MySQL Installer for Windows.' I like to use MySQL Installer 8.030, so I will download it from the archive. If you want, you can download this version. 

Look, there are two options for downloading: online or offline. You can download either one. I will download the offline version. You don't need to log in or sign up. With the 'No thanks' button, you can download it. Now, the file was downloaded; now run the installer. If you want, you can select the default or full option. But I only want to install the MySQL server and Workbench, so I will choose custom. Click 'Next.'

Now, in MySQL server, we will select MySQL server, move it to the to be installed area. Now, in applications, also I will add a Workbench to be installed. Now, click 'Next.' Now, click 'Execute.' After completing, click 'Next.' Click 'Next' again. Look, the port is 3306. Click 'Next' again. Select to use the strong password option and click 'Next.' Now, you need to determine a password for login. This password is for the root user. If you wish to add another user, click the 'Add User' button. The host will be local host. After entering the password, you can add up by clicking the 'OK' button. 

However, I do not require another user, so I'd like to use the root account. Click 'Next' again. To apply configurations, click 'Execute.' Now, finish. Configuration completed, click 'Next.' Uncheck Start MySQL Workbench. Now, finish. Done. Now, in the start menu, search environment. Click on 'Edit the System Environment Variables.'  Click 'Environment Variables.' Now, in this area, we will add the bin folders path of the MySQL server.

In the C program files, you can find MySQL. MySQL server 8, now copy the bin folders path. Paste it in system variables. Click 'OK,' 'OK' again, and lastly 'OK.' Now, we installed MySQL server open command window. With MySQL - - version, you can see here MySQL server version. Now, open Workbench. You can see MySQL connection. Click 'Root.' Look, our Workbench is ready. Let's add a database. The name will be firstsDB. Okay, done. We have now finished the installation. We will use the MySQL server in the following videos. Let's take a short break. So, I'll see you in the next video.

 

About the Author
Students
2004
Courses
64
Learning Paths
4

OAK Academy is made up of tech experts who have been in the sector for years and years and are deeply rooted in the tech world. They specialize in critical areas like cybersecurity, coding, IT, game development, app monetization, and mobile development.