MYSQL 5.7.14 Decompression Version installation steps detailed _mysql

The following is divided into five major steps to introduce you to the MySQL 5.7.14 version of the installation tutorial. Interested friends to take a look at it.

The first step: Download the latest MySQL file and unzip:

Download the latest version of mysql–mysql-5.7.12 download address

Unzip the downloaded file to your favorite location, for example, my own location is D:\MySQL\mysql-5.7.12-winx64

Step Two: Configure environment variables

It's not much to say that the bin directory is configured below the path.

Step three: Add a configuration file

Copy a My-default.ini file directly below the decompression path, rename it to My.ini, and edit the file as follows:

<code class= "Hljs Tex has-numbering" style= "display:block; padding:0px; Color:inherit; Box-sizing:border-box; font-family: "Source Code Pro", monospace;font-size:undefined; White-space:pre; border-radius:0px; Word-wrap:normal; background:transparent; " > <span class= "hljs-special" style= "Box-sizing:border-box; Color:rgb (102, 102, 0); >[</span>mysqld<span class= "hljs-special" style= "Box-sizing:border-box; Color:rgb (102, 102, 0);" "] </span> basedir=d:<span class=" Hljs-command "style=" Box-sizing:border-box; Color:rgb (0, 0, 136); >\mysql</span><span class= "Hljs-command" style= "Box-sizing:border-box; Color:rgb (0, 0, 136); >\mysql</span>-5.7.12-winx64<span class= "Hljs-command" style= "Box-sizing:border-box; Color:rgb (0, 0, 136); >\ </span>datadir=d:<span class= "Hljs-command" style= "Box-sizing:border-box"; Color:rgb (0, 0, 136); >\mysql</span><span class= "Hljs-command" style= "Box-sizing:border-bOx Color:rgb (0, 0, 136); >\mysql</span>-5.7.12-winx64<span class= "Hljs-command" style= "Box-sizing:border-box; Color:rgb (0, 0, 136); >\data</span><span class= "Hljs-command" style= "Box-sizing:border-box; Color:rgb (0, 0, 136); >\ </span>port=3306</code><ul class= "pre-numbering" style= "Box-sizing:border-box"; Position:absolute; width:50px; top:0px; left:0px; margin:0px; padding:6px 0px 40px; BORDER-RIGHT:1PX Solid RGB (221, 221, 221); List-style:none; Text-align:right; Background-color:rgb (238, 238, 238); ><li style= "Box-sizing:border-box; padding:0px 5px; " >1</li> <li style= "Box-sizing:border-box; padding:0px 5px; " >2</li> <li style= "Box-sizing:border-box; padding:0px 5px; " >3</li> <li style= "Box-sizing:border-box; padding:0px 5px; " >4</li> </ul>

There are two main issues to be noted here:

1, Basedir is the top of your MySQL file to extract the path.

2. Under this path, create a new empty folder named Data, which is datadir.

Step Fourth: Initialize the database and configure the service

Before doing this step, be sure to pay attention to two questions!!! Remember!!!

First: To the administrator himself to open cmd;

Second: Use the CD command to enter your MySQL file decompression path!

Then execute mysqld--initialize--user=mysql--console

After the successful execution, the original password of the database is at the back of the printed text, remember to copy it down, use the mouse to select, enter a place to find a local CTRL + a line.

After the above is done, then the administrator himself open cmd execution

Mysqld--install mysql–> Add to System services 
net start mysql–> start MySQL Service

Fifth step: Modify MySQL's initial password

1, open cmd execution: mysql-u root-p

2, enter the database you just saved the initial password.

3, execute Set password = password (' ***newpassword*** ');

Enter your own new password on the newpassword position.

The above is a small set to introduce the MySQL 5.7.14 decompression version of the installation steps, I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!