Hello Friends, welcome to my new tutorial. In this tutorial, we will see how to install MySQL in Windows 10 with the latest MySQL database server version 8.0.28. MySQL is a relational database management system (RDBMS) developed by Oracle, and it is based on structured query language (SQL).
MySQL is one of the most widespread Open-Source database system in the world. Some of the websites that use the MySQL database are YouTube, Paypal, Facebook, LinkedIn, Netflix, etc. Now you can imagine how powerful and popular MySQL is.
So without further ado, let’s start our tutorial on how to install MySQL on Windows 10 step-by-step with the latest server version 8.0.28.
How to Install MySQL in Windows 10 | Server 8.0.28
Downloading MySQL Installer 8.0.28(Step 1)
- We need to download the MySQL installer for Windows in the first step.
- To download the installer, visit the official website of MySQL through this link. www.mysql.com
- After visiting the website, click on the DOWNLOADS menu button, as shown in the image below.
- After clicking on the DOWNLOADS menu, scroll down the webpage, and you will find a link MySQL Community (GPL) Downloads » . Click on that link to proceed further, as shown in the image below.
- After reaching there under community downloads, click on MySQL Installer for Windows because we want it for Windows 10.
- After that, you will find two download buttons for the MySQL Installer. The first one is the web Installer, and the second one is the one we will download to our system.
- There you can see the version of the MySQL Installer is 8.0.28 while I was writing this post, and it may differ when you will read this article. The Installer is for a 32-bit operating system, but you don’t need to worry about that because it works for both 32-bit and 64-bit operating systems.
- After clicking on the download button, it will ask to login or sign-up for the Oracle web account. You can login or sign-up for the account if you wish to otherwise if you are only concerned about downloading the file, then click on the link No thanks, just start my download as shown in the figure below.
- The file will start to download. Wait till it finishes.
Installing MySQL Installer (Step 2)
- After you have downloaded the file, locate the file’s location in your system and then double click on it to start the installation process.
- After the installation starts, it will ask you to choose the setup type, and I will select the custom installation, as you can see in the figure below and then click on the Next button to proceed.
- Custom installation allows you to select exactly which products you would like to install.
- After that, select the products that you want to install and move them to the right side using the arrow button where “Products To Be Installed” is written.
- I will install three products
- MySQL Server
- MySQL Workbench – The GUI application to develop for and manage the server.
- MySQL Shell – The new MySQL client application to manage MySQL Servers and InnoDB cluster instances.
- Then click on the Next Button.
- Then it will show that the following products will be installed.
- Click on the Execute button to proceed.
- After the installation is finished, you will see the status is complete with the green tick.
- Click on the Next button to proceed further.
- Next, it will show that the MySQL server is ready to configure and then click on the Next button to proceed.
- Next, it will ask you to choose the server configuration type for the MySQL Server installation and how you would like to connect to this server.
- Leave it as default and click on the Next Button.
- Next, it will ask you to choose the authentication method.
- Select “Use Strong Password Encryption for Authentication.” as it is based on improved stronger SHA256-based password methods, and it is also recommended that all new MySQL server installations use this method going forward.
- Then click on the Next button.
- Next, it will ask you to enter the password for the root account, and it is recommended that you store the password in a secure place so that no one has access to that.
- You can also add new users for your MySQL applications and assign them roles consisting of a set of privileges.
- To add a new User, click on the Add User button.
- After you click on the Add User button, a new window will be opened, and there you have to specify the username, password and database role and then click on the OK button to add the user.
- Then click on the Next Button to proceed.
- Now you will see the Window Service and the Window Service name as MySQL80. Everything is fine, and you need to click on the Next button to proceed.
- Now you will see the Apply Configuration Window. Click on the Execute button to apply the configurations.
- Then it will show the message The configuration for MySQL server (server version) was successful.
- Click on the Finish button to continue.
- Now you will see the Product Configuration window
- Click on the Next button to continue.
- Now you will see the Installation Complete window.
- Click on the Finish Button as we have Completed the Installation process of MySQL on windows 10 with server version 8.0.28.
Setting the Path for MySQL Tools (Step 3)
In this step, we will set the path of the MySQL tools and add the path name of the MySQL bin directory to the windows system PATH environment variable.
- Go to the Control Panel.
- Select System as shown in the figure below.
- Then select Advanced System Settings as shown in the figure below.
- After you click on the Advanced System Settings, a dialog box will appear, and at the Advanced tab section, you need to click on the Environment Variables, as shown in the figure below.
- Next, you will see that another dialog box will appear after clicking on Environment Variables, and then under the System variables section, you need to double click on the Path.
- Next, you will see another dialog box that will appear where you have to click on the New button, and then you have to paste the complete pathname of the MySQL bin directory. For example – ( C:\Program Files\MySQL\MySQL Server 8.0\bin )
- Next, click on the Ok button to complete setting the Path process.
Creating Database in MySQL Command Line Client (Step 3)
As we have completed the installation process as well as we have set the path ,now we will create a database in MySQL using the command line client to check whether it is working or not.
- Open MySQL Command Line Client and then enter the password.
- It is the same password you gave while installing the MySQL server in your system.
- Enter the correct password and click the enter button.
- Now to create the database, give the query like this CREATE DATABASE databasename;
- For this example, I am going to create the database student.
- Write the query and press enter to create the database.
CREATE DATABASE student;
- To check whether my Database has been successfully created or not, we can again give the query SHOW DATABASES;
- You can see the figure below to understand.
- As you can see in the figure above, we have successfully created the database name as student.
Creating Table inside Database in MySQL (Step 4)
- To create a table inside the database, first we need to use that database using the following query.
Now to create the table, we can give the query like this.
CREATE TABLE table_name (
- For this example, I am going to create a table Mehtab with the following fields.
CREATE TABLE Mehtab(Name varchar(30), City varchar(30));
So this was all from this post How to install MySQL on Windows 10 with server version 8.0.28 step by step. Don’t hesitate to comment below if you have any doubt regarding this post.
People are also Reading…..
- Best Java Books For Beginners
- How to Install MySQL Workbench on Windows, Mac and Ubuntu OS
- How to Connect MySQL Database in Java Using Eclipse
- How to Connect MySQL Database in Java Using Notepad
- How to Create Login Form in Java Swing
- Java Text to Speech
- Registration form in Java with Database Connectivity
- How to Create Mp3 Player in Java
- Java Button Click Event