Hello guys, welcome back to CybercityHelp once again. 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 know each and every basics of MySQL.
However, if you don’t know these basics, so we kindly suggest you to read our previous article before installing MySQL. Here is the link of previous article: MySQL Basics: Defination, Types, Languages and Importance
So in our today’s article, we are going to discuss about how you can install MySQL in any operating system such as windows, linux, macOS or even ubantu. All steps are merely same but slightly different. So let’s understand the process of installation.
Guys, installing MySQL is pretty simple, just you need to follow our installation guide. You just have to read and apply each step one by one. That’s all, so let’s get started..
Installation Guide for installing MySQL on your Computer:
So we have explained it’s all 7 steps with examples to install MySQL. So kindly follow each of them one by one:
1. Download MySQL Installer
So the very first step is to download MySQL Installer. Inorder to download this Installer, just open your browser and search for “install MySQL” You will see some web pages. The official website is “MySQL Developer Zone” so just click on those links where this website is mentioned. If you see that, you are right at place. If you’re unsure about the website, so you can directly visit the official website via this link: MySQL Developer Zone.
Once you enter in the official website, you will see a interface where “MySQL community downloads” will be mentioned. Then go down and select version as per your operating system. If you are using Microsoft windows, then you may use version like 8.0.43. Then, as per your system specifications, you may download the desired one. If you’re using windows 11, you may download from the second option “Windows (x86, 32-bit), MSI Installer” which is of 353MB. So download that one first.
However, don’t forget that, these versions and options might get changed in future, and also it depends on your operating system. So kindly first know your operating system and then find out the suitable version based on your system requirements and architecture.
2. Permissions and Setup
Now the second step we have is permission and it’s setup. So once you open its downloaded file, it will ask you for permission. So click “Yes” and then another permission will appear, so just click “Yes” to every permission.
After that, a page will pop up on your screen asking what kind of setup you want. So do not go for “Full” option because in that case, you will get a lot of tools that are not required. Here, we will go for a “Custom” download. In the custom setup, click “Next” from the servers, then select the MySQL server. Then choose the first file and click on the arrow so that it moves to the right-hand side.
Similarly, in applications, go for Workbench. Choose the Workbench and move it to the right-hand side. Lastly, we have documentation, where we have samples and examples. These are nothing but practice databases. These are the three things we need as of now. Once you have all these three things selected, click “Next“..
3. Download and Install
So now, it will ask you to download the selected files. So click on “Execute” then it may take some few seconds or minutes, because it depends on your PC’s performance and your internet connection. So let it get done first.
Once it is downloaded, click “Next” and now it is ready to install. Then click on “Execute” to install all three apps. Wait for it to be installed. Once it is done, then click “Next” so here you might get some details, so just don’t touch anything, and click “Next” again.
4. Set a Password
Now after downloading, we have to set set our password. So now it will ask you to create a strong password. But make sure to choose a password that is easy to remember. It might say the password is weak, but still, make sure it is easy to remember. In case if you forgot your password easily, so you may note your password somewhere to remember.
So now click “Next” then, click “Execute” and wait for a few seconds. Once it is executed, click “Finish” then “Next” Now, you will be asked for the password again. Write the same password you mentioned before and click “Check” to see if the connection is successful. Click “Next” then “Execute” and finally click on “Finish” so now it’s done.
5. Open MySQL Workbench
Now after setting up the password, se will move towards MySQL workbench, so once you click on “Finish” it will automatically open the Workbench. If it does not open, then, you can go to your search bar, write “Workbench” and it will display MySQL Workbench afterwards.
Here, we have a local instance MySQL 8.1 so click on this, it will ask for your password. Write your password and click on “Save Password in Vault” so that you don’t have to enter it every time you open MySQL. Once you click “OK” it will open MySQL’s interface for you.
6. Understand MySQL Interface
So once you get MySQL interface, so on the left-hand side, this Navigator is for management and administration. You will see another tab called “Schemas” In these Schemas, there are three databases that were provided. If you remember, we installed samples and examples, these are those databases.
For example, if you open “sakila” you will see different tables such as actor, category, city, country, customer. These are sample tables for practice. If you want to see a table, like “address” click on it, and it will open along with all its columns.
Now on the right-hand side, there are SQL editions. If you don’t want it for now, you can disable it. Your query window will be fully visible. You can increase the font size by pressing and holding “Control” and moving your cursor. To run a query, press “Control+Enter” that’s all.
7. Understand Output
Now the last step we have is our output. So the top section is for writing queries. The center shows the table, and the bottom shows whether the action was successful or not. You can collapse this bottom section if you don’t want to see it. Whenever you want to check the output or errors, you can reopen it. So yeah that’s all.
Alright, so these were the steps by which we can install MySQL in any operating system. However, we took example of windows, but if you use any other operating system like Ubantu, Linux or even MacOs. So it’s still the same. Only you need to download the different MySQL file and different version as per your system requirements and architecture. So kindly read that and then download. After that, same process is applied in all the operating systems.
We hope that you must have understood each and every steps of MySQL installation guide, in case if you still have any doubts, you can comment below, we will try to answer you as soon as possible. And yeah, we will bring more articles about MySQL in future to teach you each and everything about it. So yeah that’s all for this article, thank you so much for reading this article till the end!
“So keep learning, keep growing!”
