Last Updated on 2020-11-09 by Clay
Introduction
I have learned about the database system and I know there are three types of database:
- Database (DB)
- Database Management System (DBMS)
- Application
The database is stored various data, and we can query, insert, update, delete ...... via database management system.
The application is usually a front-end user graphical interface.
So I will start to introduce how to install MySQL, a fairly well-known database system.
Download of MySQL
First, we come to the official website of MySQL: https://dev.mysql.com/downloads/mysql/
- Select your operating system, here I use Windows as a demo.
- Go to download page
There is a web version and a general version here. Just choose the general version for now.
No need to register, press No thanks, just start my download and the download will start.
MySQL Workbench
MySQL Workbench is an application that can help us to operate MySQL, the latest version will auto install when we install MySQL. So if you have installed it, you can pass this step.
Of course, you can also download it if you don't have it.
First, come to the MySQL Workbench download page: https://www.mysql.com/products/workbench/
Click the download button.
Select your operating system and download.
Similarly, it is not necessary to register or log in to download.
Installation of MySQL
Click to install the MySQL installation file just downloaded. There may be a lot of steps, but the installation speed is fairly fast.
If I skipped the steps and did not cut to the picture, in fact, I just choose the next item. The default installation is usually the lightest and least additional package. The only important thing is to set the root password.
It is very important here, to set a password that will not be forgotten, preferably a strong password.
Give this server a name.
Here you can enter the Root password you just set again to check whether the input is successful. Select Next again when finished.
The first thing that jumped out was the MySQL command line, which can be closed and just operate MySQL Workbench.
In the case of automatic installation of MySQL Workbench (or it is already installed in your computer), this interface will automatically pop up; if you do not jump out of this interface, you can go back to the previous section to manually install MySQL Workbench.
Choose this MySQL database we just configured.
Enter the password you just set.
Go to "query 1" and write the following command:
show database;
If you can see the displayed results (your results may be different from mine), it means that our database is set.