Shulou(Shulou.com)06/02 Report--

This article introduces the "detailed installation steps of MySQL" related knowledge, in the actual case operation process, many people will encounter such a dilemma, and then let the editor lead you to learn how to deal with these situations! I hope you can read it carefully and be able to achieve something!

1. Several points we need to pay attention to before installation: do not install the latest version, but generally look for the mysql5.0 series version; mysq1 official website has .zip and .msi installation forms; zip is a compressed package, which is directly unzipped and used later, so you need to configure various things by yourself; msi is an installation package, and the system helps us install it directly; beginners suggest using msi installation; 2, mysql download address

Https://dev.mysql.com/downloads/windows/installer

Step 1) double-click the installer below.

2) after the following interface appears, check "I accept the license terms" and click "Next". 3) after the following interface appears, select "Custom" and click "Next". 4) after the following interface appears, we do the following. 5) at the same time in this interface, you can also view the default installation path of "MySQL Server 5.7.21-X64".

Note: step 5 here, you must follow what I said here, do it again.

Step 1: select "MySQL Server 5.7.21-X64" first.

Step 2: click "Acvanced Options" in the lower right corner. Step 3: at this point, the following interface appears. Note as follows: 6) after the following interface appears, prove it is OK, click "Execute". 7) when the following screen appears, click "Next". 8) when the following screen appears, click "Next". 9) when the following interface appears, check the content in the red and yellow box and click "Next". 10) when the following interface appears, use the default content of the interface and click "Next". 11) when the following screen appears, after setting the password, click "Next". 12) when the following screen appears, after making the following settings, click "Next". 13) when the following screen appears, click "Next" directly. 14) when the following screen appears, click "Next" directly. 15) when the following screen appears, click "Execute" directly. 16) when the following screen appears, click "Finish" directly. 17) when the following screen appears, click "Next" directly. 18) when the following screen appears, click "Finish" directly. 19) configure environment variables

In step 5 above, we know that the database management system (Mysql Server) is installed in the following directory: we find the installation directory of mysql server: C\ Program Files\ MySQL\ MySQL Server 5.7, and enter the bin directory, where there will be a lot of "binary executables".

Using the mysql.exe executable file, you can connect to mysql, but you can't double-click here, even if you double-click, it just appears a "splash screen". Mysql.exe executable file, which can only be run in a CMD black window. In the CMD black window, you can execute this executable file if you configure it without configuring environment variables. When you do not configure the environment variable, you can only change to the directory where mysql.exe is located to execute the mysql startup command; when you configure the environment variable, as long as you open the CMD window, you can execute the mysql startup command in any path. When no environment variable is configured; configure environment variable; open my computer-> Properties-> Advanced-> Environment variable, select PATH in the system variable. You only need to add the following two points: why does ① need to configure environment variables? An environment variable that represents a global search path for the system. When you do not configure environment variables, if you want to execute a program in a directory, you must find its exact location before you can execute it. If you think about it, if you want to execute a program in another directory under another file path, do you think it's okay? When you do not configure environment variables, do you want to execute a program? Of course, it is possible to start mysql, for example, if you do not configure environment variables, you must use the cd command in the CMD black window to change to the bin directory under mysql server before you can perform startup. Is it troublesome for you to start like this every time? when you need to use mysql frequently, you need to perform mysql startup frequently. This is why we need to configure environment variables. When an environment variable is configured, if you want to execute a program, you can execute the program in any path. First of all, the system will search the current directory to see if there is a program you want to execute. if not, the system will search the directories in the system environment variables one by one, and when the program is found, it will be executed immediately. 4. Explain several important installation directories in mysql

In step 5 above, we learned that the database management system is installed in the following directory:

1) enter the path: C:\ ProgramData\ MySQL\ MySQL Server 5.7.

There is an important directory and an important configuration file, which we need to pay attention to: for the detailed description of the configuration file my.ini, you can refer to the following URL: https://blog.csdn.net/hanwuqia0370/article/details/85680775 for this data directory, first see what is inside: you can see from the above figure: the default database of the system:

2) after installing mysql, pay attention to distinguish the functions of the following directories.

The specific installation locations of each of the above directories are described in detail in steps 4 and 5 of installing mysql:

5. How to check whether the MYSQL service is started in Windows? 1) in the lower left input box (or use Win + R in win7 to open the search box), enter "services.msc". 2) when MySQL is started, a MYSQL service process appears here to check whether MYSQL is started. This is the end of the detailed installation steps of MySQL. Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.