How to install MySql from Zip file in Windows 10, 11?

the image was taken from the link

Well, installing the installer (.msi) of any software is easy stuff and for everyone, it is a preferable task in our professional career, but what if there are circumstances where you have no access to the installer version of the setup?

I am giving a step-by-step guide to install one of the most used database management systems MySql from a non-installer (.zip) file.

Follow the steps:

1: Download the required version of the MySql file from the official webpage https://dev.mysql.com/downloads/mysql/5.7.html, and choose the preferred version based on OS you are using (64 bit/32 bit).

Download the MySql ZIP file to your computer

2: Extract the zip folder to the desired location on your computer.

Extract the zip file anywhere on the computer

3: Open CMD with administrative privileges from the start menu.

4: Traverse to the MySQL folder that you recently extracted.

go to the bin folder in the MySQL directory

5: Type the following command to run the MySQL console window.

mysqld — console

6: Open another CMD window with administrative privileges and type the following command, to create a root user without a password.

mysql -u root — skip-password

7: Change the user and add a password to the user that you want with the following command;

alter user ‘root’@’localhost’ identified by ‘mypass’;

8: Type the following command, it will ask for the password, enter the password, and it will open the MySQL shell for you.

mysql -u root -p

9: Type the following command and hit enter, it will create a new database.

create database test_db;

10: Type the following command to check whether the database is created or not?

use test_db;