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

Chapter 1 installation and configuration of MySQL 1.1 download and install MySQL database on the windows platform

Windows Community version download address: [https://dev.mysql.com/downloads/mysql/](), in which there are two main installation packages, one is the MSI installation package, the Windows Installer package, which is actually a database that contains the information needed to install a product and the instructions and data needed to install (and uninstall) the program in many installation situations. Through the prompts given by the installation, users only need to choose, various configuration files are installed and suitable for people who have just come into contact with them; the other is the .zip installation package, which requires self-configuration and is suitable for people with some experience in using databases.

1.1.1MySQL download

Download address of MySQL official website: [www.mysql.com] (). MySQL database is divided into community version (Community Server) and enterprise version (Enterprise), the community version is free to download and completely free, but the government does not provide any technical support, which is suitable for most ordinary users; the enterprise version is charged and cannot be downloaded online, providing more features and more perfect technical support, which is more suitable for enterprise customers who require higher functions and reliability of the database.

Go to the MySQL official website: [www.mysql.com] () download mysql

Click to enter the official website as follows:

Click downloads, and select the MySQL Community Server version to download, as shown below:

MySQL download page, Select Operating System is the choice of the appropriate operating system, Looking for previous GA versions? Select the old version, and Go to Download Page > select the MSI installation package to install. You can choose the desired version to download, as shown below:

Download the MSI installation package for 32-bit or 64-bit machines. You can choose during the installation process. Click Download to download the 64-bit installation package, as shown below:

Click Download to enter the download page and select No thanks, just start my download can start to download, of course, you can also choose to register or log in to an Oracle Web account to download, so the mysql-installer-community-5.7.27.0.msi installation package download is complete.

1.1.2MySQL installation

Double-click the mysql-installer-community-5.7.27.0.msi installation package you just downloaded, install MySQL, select accept license, and then click next to proceed to the next step.

First of all, there are four installation types (Choosing a Setup Type): Developer Default as the default installation type, developer machine; Server only as the server only; Client only as the client only; Full full installation type; Custom user-defined installation type. Here we choose the default installation type and click next to proceed to the next step.

This step is to check the installation conditions and go directly to the next step.

Select Execute to install the components that need to be installed by default:

After the installation is complete, select next to proceed to the next step:

Select next configuration component installation information:

Select the first item for high availability configuration, and then next goes to the next item:

Type and network configuration. There is no special requirement for port number. Choose the default configuration. Click next to proceed to the next step:

Set the account root password and role settings. Set the root password to root123456. Please set your root password as needed, and then click next to proceed to the next step:

This interface is used to set whether MySQL is a service of windows. If so, set a service name and whether it is automatically loaded when windows is restarted. Select the default option here. Set the service name of registration on windows to MySQL57, and the service is enabled when the system is enabled. Click next to proceed to the next step:

Click Excute to execute the modified component configuration above to make it effective:

Click finish to complete the installation and proceed to the next step of configuration:

Mysql Server5.7.27 configuration is complete, then configure MySQL Router and Samples and Examples:

Set MySQL Router to use, select the default setting, and click finish:

Connection test, enter password root123456 test is successful, click next to proceed to the next step:

To apply configuration and script execution, click Execute execution:

Click finish to finish:

To show the result of component configuration, click next to proceed to the next step:

Click finish, complete the installation, and open MySQL Shell and MySQLWorkbench:

Use MySQL Shell8.0 to connect to the database, enter the password root123456, and connect successfully:

To log in to mysql using the cmd window, you need to add mysql to the environment variable and set the environment variable in the Control Panel-"system -" Advanced system Settings:

Modify Path and add C:\ Program Files\ MySQL\ MySQL Server 5.7\ bin to the environment variable:

Enter the path to MySQL and click OK:

Run cmd, enter mysql-u root-p, and follow the prompts to enter the password. Login is successful:

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.