1. Download and install MySQL database: (1)---My tags, software download, computer-related professional software---baidu cloud link download Mysql-installer-community-5.7.18.1msi (the installation version of the current time is the latest version of) non-installed version requires the use of command configuration, a little cumbersome, recommended to use the installation version, more convenient. (2) can also download the latest version of the MySQL official website: https://dev.mysql.com/downloads/installer/(official website)
Note: In the process of installing MySQL database, remember the user name and password, it is recommended to use easy-to-remember user name and password, the installation path is best to choose non-system disk, remember the path, easy access to the database, in addition to MySQL database completely free of charge.
2. Test whether the database is available. First step: Check whether the MySQL database starts:-> run (win+r), input services.msc-> Local service, start mySQL57 The second step: check that the MySQL database is configured successfully:-> run- Enter cmd (case can), go to the bin directory of the MySQL database: d:->cd D:\MySql\MySQL Server 5.7\bin (go to the bin directory according to your MySQL installation path, my installation is: D:\MySql\ MySQL Server 5.7\bin)
Command: mysql-u root-p-> Enter the password for the login database if you see the following prompt for configuration success Note: If you do not want to log in to the database every time, you can configure environment variables, in the environment variable-system variable path to add url:d:\mysql\ MySQL Server 5.7\bin
When you are finished, you can enter the MySQL command directly under the current computer User:
Note: The article for my original, reproduced please indicate the source! The article will inevitably have flaws, but also hope that we contain more, there is advice or suggestions can contact with me; I qq:2187093468 (non-sincerity, please add friends where the note where to see)
MySQL database built under Windows platform