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;

--

--

--

I am a Software developer, professional in Laravel, Spring Boot, and Angular frameworks. I am also an IoT researcher and enthusiastic.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

How to Push to GitHub without Typing your Password every time.

Autoscaling with Zapier and Cloud 66

Removal of Non ASCII characters using Python

Binary Search Tree for Dummies

Beginners guide to REDIS

🏦第81周发币数据总览🏦

Test Driven Development: What it is and How we do it.

Data collection by web scrapping with python

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Sayed Hussainullah Sadat

Sayed Hussainullah Sadat

I am a Software developer, professional in Laravel, Spring Boot, and Angular frameworks. I am also an IoT researcher and enthusiastic.

More from Medium

Alerting using SMTP

My Docker problems — Networking & Volumes

Jenkins error — Starting Jenkins /etc/rc.d/init.d/jenkins: line 115: img-src: command not found

Jenkins error - Starting Jenkins /etc/rc.d/init.d/jenkins: line 115: img-src: command not found

How to get into a Remote Server — Part 2 & 3