Windows installation mysql5.7

1. Search "Mysql Download" to enter the official website or click the link https://dev.mysql.com/downloads/ to enter the official website, as follows:

2. Download the corresponding MySQL version as follows:

• Click MySQL on Windows---MySQL Intaller, as follows:

• drop-down see below, you can see the latest version as follows (of course, there are also historical versions of the selected entry, such as):

Download the selected version of the image file can be installed after ~ ~

PS: If only see the download file in the zip format, did not find the image file download, you can refer to:https://www.cnblogs.com/ostrich-sunshine/p/9296646.html

3. Install MySQL

Bo Master download is mysql-installer-community-5.7.22.1.msi, double-click Download Good image double-click download good mysql installation file "Mysql-installer-community-5.7.22.1.msi," Open the installer, you need to wait a moment to open it:

Tick agree, Next, select the type of installation (depending on your needs):

• Developer Default: Developer defaults
• Server only: Servers only
• Client only: Clients only
• Full: Fully
• Custom: User-defined

Here we choose custom (customized) installation, where we need to choose the MySQL server we need from the installable product (products) provided by the installer, as follows:

We expand the first "MySQL Servers" in Available products, expand its sub-nodes in turn, until its terminal node, my operation is 64-bit, so check "MySQL Server 5.7.22-x64"

Then click the green Rightwards arrow, move the current Product to the list that needs to be installed, then expand the MySQL Server 5.7.22-x64 item to the right, and the rest of the product is similar, click the "Next" button to proceed to the next step.

The blogger's additions are completed as follows:

Next, click "Execute" to start the installation, the installation process will show the installation of the Progress (progress), waiting for the installation after the Status will show the Complete,mysql icon will appear before a green tick, and then click "Next" button to enter the product configuration interface:

Next,config Type Select "Development Machine", select this will use smaller content to run our MySQL server, corresponding to small software, learning is fully enough. After "Next":

In root account Password set the password of the database root, I filled in 123456, so the program reminds me that the password strength is weak, we need to remember this password, and then click "Next":

Here you can set the name of the MySQL server and whether to boot, I did not change, I can change, click "Next":

Click "Next":

Tick means "Enable X protocol/mysql as document Store", here unchecked, continue "Next":

This interface applies the configuration previously set to our MySQL server, click "Execute" and wait for the completion to complete:

Configuration complete, click "Finish" to complete the configuration link.

7. After the configuration is complete, we will go back to the installer and click "Next" to continue:

Prompt us to install complete, click "Finish":

All the way down, you can see:

If selected above, the Workbench tool interface and MySQL Shell interface will appear, the Shell interface is as follows:

If not checked, then click "Finish" after the computer is so calm, let people do not know what to do next! Experience of installing software in the past this time the computer should automatically start the software that has just been installed. So I looked in the process and did not find a mysql-like process, so we went to the next step.

Iii. Configuring the MySQL environment variable (not necessary) Description: After configuring the environment variables for MySQL, we can run MySQL (open, stop, etc) in CMD 1. As in fact, the environment variable configuration method, we open the Environment Variable configuration window (combination key win+pause, change settings, System Properties, select "Advanced" Environment variable) 2. Select "Path" in the system variable, enter the path of the Bin folder under the MySQL installation directory at the beginning of the path value: C:\Program files\mysql\mysql Server 5.7\bin, save exit Note: MySQL The default path for the server installation is: C:\Program files\mysql\mysql server 5.73. Test is configured successfully: Open cmd, enter "Mysql-u root-p" and enter the password for the root account set at MySQL installation (123456), if prompted "Welcome to the MySQL monitor." Description the configuration was successful. Iv. start MySQL Yes, by now we haven't started our mysql!. So how do you start it? (based on the condition of the configured environment variable) 1. Run cmd as an administrator, enter "net start Mysqlzzz1" (MySQLZzz1 is the server name that is filled in when you configure MySQL server, and CMD is not case-sensitive and can be used)   2. When the prompt starts successfully, we can see the "Mysqld.exe" process in the Task manager's process.  : If the command is executed: The service name is invalid. Please type NET helpmsg 2185 for more help. Workaround:  Execute the mysqld-install command with administrator privileges in the MySQL Bin directory with the method of uninstalling the MySQL service. 1, with administrator permissions net stop MySQL, turn off MySQL service 2, with Administrator's permission mysqld-remove, uninstall MySQL service Five, test whether the installation is successful we use the MySQL management software (Navicat for MySQL) to test the connection, Make sure that MySQL is ready to use: 1. Open Navicat for mysql 2. Create a new connection, fill in the connection information: Connection name: Used to differentiate between different connections, name your host name: localhost port: 3306 user name: root password: 123456 (password entered when the MySQL was configured) 3. Click the "Connect Test" button, the pop-up connection dialog box indicates that MySQL server is turned on    4. Then the use of navicat for MySQL software         Another: We can also enter "net start mysqlzzz1" in cmd, if prompted "the requested service has been started." "indicates that MySQL server has started properly;  to this point, MySQL server is installed on Windows 10 64-bit.   Reference:52446608

Windows installation mysql5.7