MySql5.7.14 installation tutorial (decompress version) and mysql5.7.14

MySql5.7.14 installation tutorial (decompress version) and mysql5.7.14

Go to the official tutorial below:

Step 1: Download and decompress the latest MySQL file:

Download the latest MySQL-mysql-5.7.12

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

Step 2: Configure Environment Variables

The bin directory can be configured under path.

Step 3: Add a configuration file

Copy the my-default.ini file under an unzipping 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 note:

1. basedir is the decompression path of your mysql File above.

2. Create an empty folder named data under the path, that is, datadir.

Step 4: Initialize the database and configure the service

Before proceeding to this step, you must pay attention to two issues !!! Remember !!!

1. Open CMD as an administrator;

Second, run the cd command to enter the decompression path of your MySQL file!

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

After the script is successfully executed, the initial password of the database is displayed at the end of the printed text. Remember to copy it and press the mouse to select it. Press enter to find a place and press ctrl + v.

After the preceding steps are completed, the Administrator opens the CMD command and runs the command.

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

Step 5: Modify the initial password of mysql

1. Open CMD and run mysql-u root-p.

2. Enter the initial password of the database you just saved.

3. Execute set password = password ('*** NewPassword ***');

Enter your new password at the location of NewPassword.

The above is a detailed explanation of the MySql5.7.14 installation tutorial (decompress version) introduced by Alibaba Cloud. I hope it will help you. If you have any questions, please leave a message and I will reply to you in a timely manner. Thank you very much for your support for the help House website!