Mysql5.7.30 installation and configuration method graphic tutorial _ MySQL

This article mainly shares a graphic tutorial on how to install and configure mysql5.7.30. if you are interested, you can refer to the tutorial on uninstalling and reinstalling MySQL on the server, I changed my computer and added the installation record. during the installation, I found some installation records from some netizens and found many pitfalls.

Cut a graph and take notes, just to friends who need it.

Full installation of MySQL 5.7.3.0

The classic MySQL database does not need to be described too much.

This article describes how to install MySQL.

1. Download Software

Here, I am using the new MySQL 5.7.3.0 version. In fact, these versions are mostly the same and can be ignored.

If you need software, you can Google it on your own. you can download the software for free on the official website. However, you may need to register an account to log on.

The installation package is as follows:

2. run the installer

Double-click the installation program and you will be prompted that the system is configuring the MySQL installation program. please wait.

That's just a few seconds.

3. Welcome page of the installer

Wait for four or five seconds to open the welcome page for the installation program.

There are three options:

1) Install MySQL Products (Install MySQL Products)

2) About MySQL (About MySQL)

3), Resource (this is to view more resources, click to go to the official website, you can view the documentation and more configuration help, etc)

So, click the first one and Install MySQL Products.

　　

4. License Agreement

After you select to install MySQL, the corresponding license agreement window is opened. after reading and accepting the license, click Next.

5. search for updates

After accepting the license, the installer will ask you if you want to connect to the network to check MySQL updates.

Based on the actual situation, here, I select "Skip the check for updates" (Skip the check for updates ). Next step.

6. select the installation type

After checking for updates, the installer will allow you to select the MySQL type and annotations you want to install.

After selecting the installation type and installation path, click next.

7. check required components

Before you start the installation, the MySQL Installer checks the components to be installed in your PC, such as the VC ++ runtime library and. net fcl.

Don't worry, because you can't cancel it either. click next. Then wait for half a minute.

8. Prepare for installation

After the required components are installed, MySQL can start to install them.

The installer displays all MySQL-related applications to be installed.

Here, you can view the status and other information of each application during installation,

Click [Execute] to start installation. You can see the installation process of each application.

Then, the installation will be completed in less than one minute.

Click next to complete the installation.

9. prepare to configure MySQL

After the installation, the next step is to configure the database,

Click next to start configuring the MySQL instance.

10. configure the MySQL instance

After entering the parameter configuration interface, you can set information such as the MySQL server type and port ,.

PS:

The difference between the MySQL server types here is nothing more than the field that MySQL is to be applied.

For MySQL of different use, the installation options are also different. For example, the Server version does not provide the option to open the Workbench program in the tray icon or install useless programs too much.

For beginners, we recommend that you do not select Server.

After the configuration is complete, click next.

11. set the MySQL account

After configuring the MySQL Server parameters, the following describes how to set the MySQL account.

The above is the password for setting the Super Administrator account (root). you can add other accounts below.

After completing the settings, click Next.

12. Server service configuration

Then configure the MySQL service name, whether the service is automatically started with the system startup, and the identity of the service.

After you finish, click Next.

13. configuration complete

After all the above configurations are complete, the system prompts that the configuration is complete. click next.

14. installation and configuration are complete.

Then the program prompts you to complete the installation and configuration. click next:

15. Complete Installation

Finally, the installation is complete.

Here, you can check "Start MySQL Workbench after Steup" (Start MySQL Workbench after installation ).

16. MySQL Workbench

A visualization tool provided by MySQL, that is, the MySQL Workbench.

If you select Server as the instance type during installation, you may not have the option to open the Workbench program by right-clicking the tray icon in the lower right corner of the system.

At this time, you can enter the bin in the MySQL installation directory to find the program running.

Open Workbench, main interface

You can see that there is an instance link option in the middle. click it to open the newly installed MySQL instance.

Of course, you can also click "+" in the upper right corner to create a new MySQL link.

On the right side is an advertisement application. after clicking it, you will jump to the corresponding website for download, rather than opening the installed application.

After you click the MySQL link, you will be prompted to enter the password to log on to the database system,

17. MySQL Workbench main interface

After logging on, you will see the main interface of the MySQL Workbench, with relatively complete functions.

18. end

At this point, the installation process is complete.

Of course, if you are not good at English or are not familiar with English programs, or do not want to use the default MySQL Workbench, no problem. we recommend it here.Navicate for MySQLThis is a Chinese character. it is very popular and powerful, but it is billed. you know it.

Or a new powerful tool:Jetbrains DataGrid. This is the software of Jetbrains, which is consistent with WebStrome, IDEA, PHPStrome, and other companies. The shortcut keys are the same as those of Android Studio.

But it is also a charge, you know.

I personally think these two are quite useful,Navicate has a problem.: After connecting to the database, even if the table name is in upper case, it is displayed in lower case. It is awkward. Of course, you can solve this problem by modifying the configuration file.

The above is how to install and configure mysql 5.7.30, and I hope it will be helpful for your learning.