MySQL Installation Guide: How to Install MySQL on Windows, Linux or Ubantu?

Hello everyone, welcome back to CybercityHelp. So in our last article, we had explained everything about MySQL Basics, basically it was an introductory article about MySQL. So we are assuming that you already know each and every basic concept of MySQL.

However, if you still don’t know these basics or are new to MySQL, we kindly suggest you first read our previous article before installing MySQL. Here is the link of the previous article: MySQL Basics: Definition, Types, Languages and Importance

So in today’s article, we are going to discuss how you can install MySQL on any operating system such as Windows, Linux, macOS, or even Ubuntu. All steps are almost similar with only slight differences. So let’s understand the complete installation process.

Guys, installing MySQL is actually very simple. You just need to follow our installation guide step by step. Read carefully and apply each step one by one. That’s all. So now, let’s get started!

Installation Guide for installing MySQL on your Computer:

We have explained all 7 steps with examples to install MySQL. So kindly follow each of these steps one by one:

1. Download MySQL Installer

The first step is to download the MySQL installer. To download it, simply open your browser and search for “install MySQL”. You will see different web pages. Click on the ones that belong to “MySQL Developer Zone”. That is the official website. If you still feel unsure, you may directly visit the official download page from this link: MySQL Developer Zone

For example:

Once you enter the official website, you will see an interface where “MySQL Community Downloads” is mentioned. Scroll down and choose the version according to your operating system. For example, if you are using Microsoft Windows, you may download version 8.0.43.

Now as per your system architecture, choose the correct file. If you are using Windows 11, you may select the second option “Windows (x86, 32-bit), MSI Installer” of around 353MB.

However, keep in mind that these versions may change in the future, and available files also depend on your operating system. So first identify your system architecture and then download the most suitable version.

2. Permissions and Setup

Once the download is complete, open the installer file. It will ask for permission. Click on “Yes” whenever permission is asked.

After that, a setup page will appear asking which type of installation you want. Do NOT choose “Full” installation because it installs many unnecessary tools. Instead, choose “Custom”.

Inside the Custom setup:

• Select MySQL Server from the Servers section and move it to the right-hand side.
• From Applications, select Workbench and move it to the right-hand side.
• From Documentation, select Samples and Examples (practice databases).

Once all three are selected, click “Next”.

3. Download and Install

Now MySQL will ask to download the selected components. Click “Execute”. It may take a few seconds or a few minutes depending on your internet speed and PC performance.

After downloading is complete, click “Next”. Now you are ready for installation. Click “Execute” once again. All three components will begin installing. After installation is complete, click “Next” and continue.

4. Set a Password

Now you will be asked to create a strong password for your MySQL server. Choose a password that is easy for you to remember. Even if MySQL shows “weak password”, it is okay as long as you can remember it.

After typing your password, click “Next”, then “Execute”. When it finishes, click “Finish” and again “Next”. Now MySQL Workbench will ask for the password again. Enter the same password and click “Check” to confirm successful connection.

Finally, click “Execute” → “Finish”.

5. Open MySQL Workbench

Once everything is done, MySQL Workbench may open automatically. If not, search for “Workbench” in your system.

For example:

Now click on the local instance (for example MySQL 8.1). Enter your password and click “Save Password in Vault” so that you don’t have to enter it again.

6. Understand MySQL Interface

Once MySQL Workbench opens, on the left-hand side you will see the Navigator panel for management and administration tasks. Below that, you will find Schemas which contain databases.

For example:

You will see many sample tables like actor, category, city, country, customer, etc. These are the sample databases we installed earlier.

On the right side, you will find the Query Editor. You can increase font size using Ctrl + Mouse Scroll. To run any query, simply press Ctrl + Enter.

7. Understand Output

The upper section is where you write queries. The middle section displays tables or results. The bottom section shows success messages or errors. You can collapse or expand it as needed.

For example:

Alright, so these were the steps you need to follow to install MySQL on any operating system. Although we explained using Windows as an example, the procedure remains almost the same for Ubuntu, Linux, or macOS. Only the file version changes according to your OS and system architecture.

We hope that you must have understood each and every step of the MySQL installation guide. However, if you still have any doubts, feel free to comment below. We will try to answer your questions as soon as possible. We will also bring more articles related to MySQL in the future so that you can learn each and every concept easily. So yeah, that’s all for this article. Thank you so much for reading till the end!

“So keep learning, keep growing!”