This is the NTH day of my participation in the November Gwen Challenge. Check out the details: The last Gwen Challenge 2021

MySQL installation procedure and procedure

1.1, double-click the downloaded mysql-installer-community-8.0.25.0.msi, the program will take some time to run, please wait, as shown in the figure.

　　 

1.2 after successful operation, enter the type selection page, select Developer Default (the Default installation step), and click “Next” button, as shown in the figure.

  • Developer default: Install all products required for mysql development
  • Server Only: Only the mysql server product is installed
  • Client only: Only the client without a server is installed
  • Mysql client Product Full (Full) : Installs all included mysql products and features
  • Custom (manual) : Manually selects a product to be installed on the system

 　　

1.3 By default, the developer detects that the following programs will not be installed successfully. Click the steps below in sequence to install them. Finally, click “Next” button and select “Yes” to enter the Next installation process, as shown in the figure. Check: The following products failed requests, and setup will automatically try to resolve some of these problems. Requests marked as manual cannot be resolved automatically. Click on these items to try manual recovery. MySQL for Visual Studio: Visual Studio version: 2015, 2017, 2019 is a code editing tool for C#, Visual Basic, C++, TypeScript, F#. Connector/pyton: if your PC has python3.6, you don’t choose python 3.4. If you don’t have Python installed, install something on request.

　　 

　 　

1.4. The program we need to install next can be seen in the interface selected for installation. Click “Execute” button, as shown in the figure.

　　 

1.5. Installation progress interface. Installation takes some time. Click Show Detail to see the installation log, as shown.

　 　

1.6. After the program is installed, click “Next” button, as shown in the figure.

　　 

1.7 You can find the program you need to configure in the Product Configutration page, click the “Next” button, as shown in the figure. Now we will introduce the configuration wizard of the following products one by one. You can cancel at any time if you wish to leave this wizard without having to configure all products)

 　　

1.8. Set the server configuration type and connection port :(keep the default, do not need to modify), click “Next” button, as shown in the figure.

Config Type: Select Development Machine.

Port: Enter 3306 or other parameters. The best value is between 3306-3309.

X Protocol Port: enter 33060

　　 

1.9 Enter the Authentication Method selection interface, keep the default, and click “Next” button, as shown in the figure.

 　　

1.10. Set the root password (remember this password), as shown in the figure.

　　 

1.11. To Add other administrators, click “Add User” button, enter the account password and click OK (if the added administrator only allows local login, change host to Local), and click “Next” button after returning to the interface, as shown in the picture.

 　　

1.12. Set the name of MySQL in Windows system, decide whether to start MySQL service after startup (it is recommended to keep the default, I don’t think it is necessary to change), and click “Next” button, as shown in the picture.

　　 

1.13. Mysql Server :Apply Configuration (application Configuration page), click “Execute” button to install and configure Mysql server. After installation, click “Finish” button, as shown in the figure.

 　　

1.14. The installer comes back to the Product Configutration page, at which point we see a successful installation of MySQL Server, click the “Next” button, as shown.

 　　

1.15, Configure MySQL Router Configuration: select Bootstrap MySQL Router for user with innoDB cluster, Hostname: enter localhost, Password: Is the password of root set before, (if you do not want to enter the password can directly click next) click Next, as shown in the picture.

　　 

1.16. Mysql Router: Apply Configuration (application configuration page), click “Execute” button, as shown in the figure.

　　

1.17. Check root password, input password, click “Check” button, click “Next” button, as shown in the picture.

　　

1.18. Click “Execute”, and click “Finish” after completion, as shown in the picture.

　　

　　

1.19. The installer goes back to the Product Configutration page and click the “Next” button, as shown.

　　

1.20. When the installation program is complete, click “Finish” button, as shown in the figure.

　　

1.21. Double-click the installation package downloaded before running, you can see the installed product, as shown in the figure.

　　

C: Program Files\MySQL\MySQL Server 8.0, select advanced System Settings > Advanced > Environment Variables > User Variables, and click Create. MYSQL_HOME, variable value: C:\Program Files\MySQL\MySQL Server 8.0, click “OK”, as shown in the figure.

　　

Find Path under the user variable, click “Edit”, click “New”, type %MYSQL_HOME%\bin, click “OK”, as shown in the figure.

　　

Open CMD, enter mysql -u root -p, and enter the password of root. Then you can successfully log in to the mysql database, as shown in the figure.

　　  　  

I am white and white I, a program yuan like to share knowledge ❤️ interested can follow my public account: White and white learning Python [very thank you for your likes, booklets, comments, three links support]