About the basic configuration tutorial of MySQL5.7.17 free installation version under Win10 (with pictures and text)

About the basic configuration tutorial of MySQL5.7.17 free installation version under Win10 (with pictures and text)

Database application is an indispensable part of an application system. Relational database applications are similar. Here we choose MySQL as the database platform.

1. mysql download

The community version of MySQL is free and suitable for developers. Download MySQL Community Server. Download URL

https://dev.mysql.com/downloads/. You can view the latest version update information of MySQL from the website.

Recommended download method: Click Other Download on the left side of the page, click MySQL Mirrors in the jump interface https://dev.mysql.com/downloads/other/, and select the mirror image you like to download. I personally feel that the ftp image is more pleasing to the eye.

2. MySQL Configuration

MySQL can be downloaded from the official website as an msi version that can be installed directly, as well as a green version that can be used directly after zip decompression. Here we use the green version for configuration.

2.1. Setting Environment Variables

In My Computer – Properties – Environment Variable Settings, add the environment variable MYSQL_HOME = D:\mysql-5.7.17-winx64, and then add %MYSQL_HOME%\bin after the path

2.2. Modify the my.ini file

The my.ini file I modified is as follows. In fact, it is just adding a client-side setting. I don’t know if it is useful. There is no such setting in the default file. Except for server_id and log_bin, which are not uncommented, all other settings are based on actual conditions and default settings. I feel that I have modified too much and many things are not necessary. However, this is the first time I set up 5.7.17, so I will leave it like this. I will study it in detail later.

I have to say one more thing. At this time, 5.7.18 is also available for download, but the my-default.ini is gone, which makes me unhappy, so I downloaded this version.

[client]
port = 3306
default-character-set = utf8
[mysqld]
innodb_buffer_pool_size = 128M
port = 3306
character_set_server = utf8
basedir = D:\mysql-5.7.17-winx64
datadir = D:\mysql-5.7.17-winx64\data
join_buffer_size = 128M
sort_buffer_size = 2M
read_rnd_buffer_size = 2M 
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

2.3. Start mysql service

Open the command prompt with administrator privileges, enter the bin directory under the mysql directory, and use the mysqld –install command to install the mysql service.

這里寫圖片描述  

Under the mysql path, manually add the data directory

mysqld –initialize-insecure –user=mysql adds files to the data directory 

這里寫圖片描述  
這里寫圖片描述  

Then you can start mysql. Use the net start mysql command

這里寫圖片描述  

2.4. Set the root password

Enter mysql and change the root password. The default root password is empty. Execute mysql –u root

這里寫圖片描述  

Switch to the database mysql, command use mysql

Different from previous versions, version 5.7 has some changes in the table structure. Use set password = password('123456'); to set the password. And flush privileges;

After completing the setup, exit mysql

這里寫圖片描述  

Log in again: mysql –u root –p

這里寫圖片描述

The above is the basic configuration tutorial of MySQL5.7.17 free installation version under Win10 introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!

You may also be interested in:
  • MySQL 8.0.15 installation and configuration tutorial under Win10
  • mysql8.0.11 winx64 installation and configuration method graphic tutorial (win10)
  • Install and configure IIS + MySQL + nginx + php7.1.7 under Win10
  • mysql5.7.19 winx64 installation and configuration method graphic tutorial (win10)
  • MySQL 5.7.19 installation and configuration method graphic tutorial (win10)
  • win10 mysql 5.6.35 winx64 free installation version configuration tutorial
  • Detailed installation and configuration tutorial of MySQL 5.7 under Win10

<<:  JS implements random roll call system

>>:  Introduction to version management tool Rational ClearCase

Blog    

Recommend

Installation tutorial of mysql8.0rpm on centos7

First, download the diagram 1. First uninstall th...

MySQL InnoDB monitoring (system layer, database layer)

MySQL InnoDB monitoring (system layer, database l...

How to use cutecom for serial communication in Ubuntu virtual machine

Using cutecom for serial communication in Ubuntu ...

How to hide and remove scroll bars in HTML

1. HTML tags with attributes XML/HTML CodeCopy co...

Native js implements custom scroll bar component

This article example shares the specific code of ...

mysql 5.7.18 winx64 password change

After MySQL 5.7.18 is successfully installed, sin...

SQL implementation of LeetCode (184. The highest salary in the department)

[LeetCode] 184. Department Highest Salary The Emp...

Implementation of MySQL select in subquery optimization

The following demonstration is based on MySQL ver...

WebStorm cannot correctly identify the solution of Vue3 combined API

1 Problem Description Vue3's combined API can...

MySQL Community Server 5.7.19 Installation Guide (Detailed)

MySQL official website zip file download link htt...

Write a simple calculator using JavaScript

The effect is as follows:Reference Program: <!...

960 Grid System Basic Principles and Usage

Of course, there are many people who hold the oppo...

JavaScript web form function communication full of practical information

1. Introduction Earlier we talked about the front...

Webpack loads css files and its configuration method

webpack loads css files and its configuration Aft...