mysql 5.7.15 installation and configuration method graphic tutorial_MySQL

As a leader among relational databases, MySQL database is not only highly sought after by the market, but also favored by programmers due to its small size, fast speed and low cost. Next, let me tell you about the download and installation of MySQL:

1. Download of MySQL

Step 1:Enter https://www.mysql.com/ in the address bar of the browser to enter the MySQL official website, as shown in the figure below:

Second step:Single-machine Download, that is, enter the following page: As shown in the figure below:

Step 3:Here are some versions of MySQL:

1. MySQL Community Server community version, open source and free, but does not provide official technical support.

2. MySQL Enterprise Edition requires payment and can be tried for 30 days.

3. MySQL Cluster cluster version, open source and free. Several MySQL Servers can be encapsulated into one Server.

4. MySQL Cluster CGE Advanced Cluster Edition, paid.

5. MySQL Workbench (GUITOOL) is an ER/database modeling tool specially designed for MySQL. It is the successor of the famous database design tool DBDesigner4. MySQL Workbench is divided into two versions, namely the community version (MySQL Workbench OSS) and the commercial version (MySQL Workbench SE).

MySQL Community Server is open source and free, and this is the version of MySQL we usually use. It is subdivided into multiple versions according to different operating system platforms.

MySQL Community Server is free and open source, so on this page we stand-alone Community. After the stand-alone is completed, it will be displayed as follows:

Step 4: Choose whether you want to download the installation version or the decompressed version. (You can check the difference between the installation version and the decompressed version on Baidu.) Let’s take the installation version as an example:

After downloading in a single machine, you will enter the following page, as shown in the picture below:

After stand-alone, you can enter the following page and download the stand-alone Download.

The download of mysql is now completed. After the download is successful, the display is as follows:

I would like to remind you here: the windows version of mysql32-bit is also suitable for 64-bit.

2. MySQL installation (Here I take the installation of mysql5.5 as an example, the installation process is similar)

(1) Double-click the file to be installed, and the following page will appear:

(2) Standalone next, the following page appears:

(3) Here we choose custom installation and stand-alone next, the following appears:

What needs to be noted here is: when setting the storage location of the MySQL server and MySQL data files, it is recommended to store them in a mysql directory file.

The stand-alone next appears as follows:

The single machine finish appears as follows:

Single machine next, the following appears:

Continue to stand-alone next, and the following will appear:

Continue to stand-alone next, the following appears:

Continue to next and the following will appear:

Continue to next and the following will appear:

Continue to next and the following will appear:

Continue to next and the following will appear:

Continue to next, and the following will appear: You need to wait for a while. After all the check boxes are automatically checked, it means that mysql is successfully installed at this time.

The installation of mysql has progressed to this point. All installations have been completed. Next, verify whether mysql is installed successfully.

Enter the command under cmd: mysql -uroot -p password (the password you set at the time). If the following is displayed, it means that mysql is installed successfully.

Here I will introduce how to start mysql and shut down the mysql service:

In cmd, enter the following command to close the mysql service: net stop mysql. The following appears:

In cmd, enter the following command to close the mysql service: net start mysql. The following appears:

The above is the installation and configuration method of mysql 5.7.15. I hope it will be helpful to everyone's learning.

Wonderful topic sharing: installation tutorials for different versions of mysql

mysql5.7 version installation tutorial