Mysql 5.7.17 winx64 installation and configuration tutorial, 5.7.17winx64

Mysql 5.7.17 winx64 installation and configuration tutorial, 5.7.17winx64

Today, I installed the MySQL database on my computer again. Every time you reinstall the system, you have to reinstall the database, but every time you have to refer to Baidu's installation and configuration tutorial. So I decided to write a blog post to introduce the installation tutorial of MySQL. This is the first time I wrote a blog post. I hope you will understand the bad news!

Next we will introduce my installation:

My computer is win764-bit. Therefore, this blog post introduces 64-bit installation.

1. So the first step is to go to http://dev.mysql.com/downloads/mysql/download windows (x86, 64-bit), ZIP Archive

2. decompress the downloaded package to the path you want to install., For example, my unzipping to the d: \ MySQL \ mysql-5.7.17-winx64 path should be these folders after decompression:

3. This step begins the configuration.If your file suffix name is not displayed, we recommend that you set your own file suffix display, because we need to use: to set the file suffix display steps: in win7, double-click "computer" --> click "Organization" under the navigation bar --> select "folder and search selection items" --> click "View" --> hide "Known File Types deselect the "extension" check box.

4.Create a new my. ini configuration file, This configuration file will overwrite the my-default.ini file under the current folder, and the previous step sets the display file suffix to be prepared for this step, open this configuration file, add the following code to the file:

Here, we want to create an empty data folder in our installation directory:

5.The previous period has been completed, and the installation service is started later. Run cmd.exe as the administrator. Remember to run cmd.exe as an administrator and enter the installed bin directory. The most important and important command is here, which is necessary. Otherwise, the service cannot be started after the installation, enter the mysqld -- initialize-insecure -- user = mysql Command, and press Enter,

6. Enter mysqld install to install the service. If the installation is successful, a prompt is displayed, indicating that the installation is successful. If the MySQL service is started, the installation is OK,

7. configure the environment variable --> right-click on the computer "properties" --> "Advanced System settings" --> "environment variable" --> "path" --> copy the path of the bin directory to the path environment variable, it is best to copy it to the beginning and add a semicolon to the end. 8.open mysql, cmd.exe, and enter the mysql-uroot-p command. By default, there is no password. Press enter to enter. If you have already set a password, you must enter it. If you have a password, you can use mysql-uroot-p or mysql-uroot-p to press enter to enter the password. The second type is recommended.

Now we are done! Enter exit to exit mysql.

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.