Tutorial on installing mysql5.7.18 on windows10

This tutorial shares the installation and configuration methods of MySQL 5.7.18 for your reference. The specific contents are as follows

1. MySQL 5.7.18 installation and configuration

1. MySQL download: https://www.mysql.com/downloads/

Download MySQL Community Server
Select the version you want to download. Here I choose the latest version 5.7.18 to download the MSI version.

Click download to go to the next page

Select the appropriate download according to your system version.
Click Next and you will be prompted to register an Oracle account. If you find it troublesome, you can skip the registration step and click No Thanks in the lower left corner to download immediately.

After the download is complete, go to your download directory and click the .msi file to start the installation

2. Here you can start the formal installation. Select the installation type according to your personal needs. Here I choose custom and click next.

3. Here we need to select the MySQL server we need from the installable products provided by the installer
Select the first expanded child node

4. After selection, the arrow turns green. Click the green arrow to move the current product to the list that needs to be installed. Then expand the MySQL Server 5.7.18x64 item on the right, uncheck Development Components, a green check will appear in front of the MySQL icon, and then click Next to enter the configuration interface.

5. Click "Next" to enter this interface and then click "Execute" to execute the installation. A progress percentage will be displayed. After the installation is completed, it will turn into a green check mark, and you can proceed to the next step.

6. Next!

7. Next, enter the configuration of MySQL Sever

8. Config Type: Select the default Development Machine. Keep the rest as default

9. Root Account Password sets the password for the database root account. I set it to mysql123. Pay attention and remember this password . Configure the environment variables and use this password to open MySQL in cmd.

10. The next step is to set the name and whether to start automatically. Of course, if you don’t need it to start automatically at boot, just uncheck it.

11. The rest is next.

Execute

12. After setting, you will return to the installation program. Continue next

finish!Yes, no automatic startup. The installation was completed so calmly.

2. How to enter MySQL?

If you want to enter mysql in cmd, you need to configure environment variables

Computer->Properties->Change Settings->Advanced->Environment Variables->New->

Variable name: Path
Variable value: C:\Program Files\MySQL\MySQL Server 5.7\bin
The default installation location is on drive C.
Open cmd like this
Type: mysql -u root -p
Enter password:
Welcome to the MySQL monitor: it can be opened.
Previous picture;

This is complete, follow-up updates!

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.