MySQL 5.7.30 installation configuration method graphics and text tutorial _mysql

Before the server inside the MySQL unload reload, install MySQL did not make a summary, change a new computer, fill up on the installation record, installation, find some users of the installation records, found a lot of pits

Cut a picture, as a note, also just for the friends who need.

MySQL 5.7.3.0 Installation Full screenshot

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

This article mainly introduces the installation process of MySQL, step-by-step screenshot, followed by the line.

1. Download software

Here, I use the new version of the MySQL 5.7.3.0, in fact, these versions are mostly the same, can be ignored.

Need the software can own Google, the official website can download free, but seemingly need to register account login to the next.

The installation package is as follows:

2. Run the Setup program

After you double-click Setup, you will be prompted to configure the MySQL installer later.

Just a few seconds. As shown in figure:

3. Welcome interface for Installer

Wait four or five seconds to open the installer's welcome interface.

As shown in figure, there are three options, respectively:

1), Install MySQL products (install MySQL product)

2), about MySQL (about MySQL)

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

So, we clicked the first one, Install MySQL products.

　　

4. License Agreement

After you choose to install the MySQL product, you open the appropriate License agreement window, and after you read and accept the license, click Next.

5. Find Updates

After you accept the license, the installer asks if you want to connect to the network to check for MySQL updates.

According to the actual situation, here, I choose the "Skip the Check for updates" (Skip check update). And then the next step.

6. Choose the type of installation

After checking for updates, the installer will let you select the type of MySQL you want to install, as shown in the following notes:

After selecting the installation type and installing the path, click Next.

7. Check the required components

Before you start the installation, the MySQL installer will check the components that are currently installed on your PC, such as VC + + runtime and. NET FCL, and so on.

As shown in figure:

Don't worry, because you also can not cancel, click Next on it. Then wait for half a minute.

8. Ready to install

After the required components have been installed, MySQL can begin to install.

At this point, the installer displays all the MySQL-related applications that are ready to be installed.

Here you can see information such as the status of each application installation, as shown in the figure:

Click [Execute] to start the installation. You can see the installation process for each application. As shown in figure:

You can then wait less than 1 minutes to complete the installation.

Installation complete effect as shown: Click Next.

9. Prepare to configure MySQL

After installation, the next step is to configure the database, as shown in the figure:

Click Next to start configuring the MySQL instance.

10. Configure MySQL Instance

After entering the parameter configuration interface, you can set up information such as its MySQL server type, port, and so on, as shown in the figure.

Ps:

The MySQL server type here is different, in fact nothing more than MySQL to apply the field.

Different use of MySQL, provide installation options are also different. The server server version, for example, will not provide the option to open the Workbench program in the tray icon, nor will it install unwanted programs too much.

Beginners, it is recommended that you do not select Server.

After the configuration is complete, click Next.

11. Set up MySQL Account

After you configure the MySQL server parameters, the following is the account you set up for MySQL. As shown in figure:

Above is the password to set up the Super Administrator account (root), which can be added to other accounts.

When you are finished setting up, click Next Next.

Server service Configuration

Then you configure the service name for MySQL, whether it starts automatically with the system startup, what identity starts, and so on. As shown in figure:

After you've finished, click Next Next.

13. Configuration Complete

All of the above configuration is finished, then prompted configuration complete, as shown in the next step can be clicked.

14. Installation & Configuration Completed

Then the program prompts you to install and configure all the things, as shown in the figure, click Next:

15. Complete the installation

Finally, Setup shows that the installation is complete.

Here you can tick "start MySQL Workbench after Steup" (Start MySQL Workbench after installation).

MySQL Workbench Workbench

MySQL provides a visualization tool, which is the MySQL Workbench Workbench.

If you have just installed, the instance type chooses server, the tray icon on the lower right corner of the system may not have the option to open the Workbench program.

At this time, you can go to the MySQL installation directory in the bin to find the program to run also can.

Open the work table, the main interface as shown:

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

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

Right is a pair of advertising applications, click to jump to the corresponding Web site download, rather than open already installed applications Oh.

Click on the link to MySQL, you will be prompted to enter a password to log in to the database system, as shown:

MySQL Workbench Workbench Main interface

After login, you will see the main interface of the MySQL Workbench Workbench, the function is relatively perfect. As shown in figure:

18. End

By this, the installation process is complete.

Of course, if English is bad or not used to English program, or do not want to use the default MySQL Workbench, no problem, here recommend navicate for MySQL, this is Chinese, very mainstream is very strong, but the charge, you know.

Or a new powerful tool: Thejetbrains DataGrid. This is JetBrains company's software, and webstrome, idea, phpstrome and so on a company, the interface is exactly the same, shortcut keys are the same, and the Android studio interface is the same.

But it's also a charge, you know.

I personally feel that these two are very useful, but navicate has a problem : After the database linked to the table name, even if it is uppercase, it also shows all lowercase. More awkward. Of course, you can fix the problem by modifying the configuration file.

This is the MySQL 5.7.30 installation configuration method, I hope to help you learn.