Detailed tutorial on configuration method of Mysql 5.7.19 free installation version (64-bit)

Detailed tutorial on configuration method of Mysql 5.7.19 free installation version (64-bit)

Download mysql-5.7.19-winx64 from the official website. Note that it corresponds to the system 64-bit or 32-bit. Here we use 64-bit.

Unzip the file and save it to a local disk. I found that the file was very large, about 1.6G. Delete the .lib files in the lib folder and all files in the debug folder.

Create a my.ini file in the home directory. The content of the file is as follows: (This is a simplified version, corresponding to the local modification of the basedir and datadir directories. You can expand the configuration yourself as needed)

[client]
port=3306
default-character-set=utf8 
[mysqld] 
basedir=D:\JavaTools\mysql-5.7.19-winx64
datadir=D:\JavaTools\mysql-5.7.19-winx64\data
port=3306
character-set-server=utf8
character-set-filesystem = utf8
sql_mode=NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER
explicit_defaults_for_timestamp=true
skip-grant-tables

4. The free installation version has no data files, so you need to create a data folder yourself. Here we start to pay attention to the order of commands

這里寫圖片描述

5. Install mysql service.

這里寫圖片描述

6. Start mysql

這里寫圖片描述 

Very important: set the root user's password, the above is a password-free login

Enter the mysql environment, mysql -u root

Change the password, alter user root@localhost identified by "12345";

Summarize

The above is a detailed tutorial on the configuration method of the MySQL 5.7.19 free installation version (64-bit) 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:
  • mysql5.7.17 installation and configuration example on win2008R2 64-bit system
  • Installation tutorial of MySQL 5.7 green version under windows2008 64-bit system
  • Tutorial on installing the green version of mysql-5.7.16-winx64 on 64-bit win10 system
  • How to install MySQL 5.7.11 on 64-bit Win10 system (case study)
  • MySQL 5.7.31 64-bit free installation version tutorial diagram

<<:  Full analysis of Vue diff algorithm

>>:  CentOS 6.5 configuration ssh key-free login to execute pssh command explanation

Recommend

js canvas realizes circular water animation

This article example shares the specific code of ...

HTML Tutorial: Collection of commonly used HTML tags (4)

These introduced HTML tags do not necessarily ful...

JavaScript recursion detailed

Table of contents 1. What is recursion? 2. Solve ...

Pure CSS to modify the browser scrollbar style example

Use CSS to modify the browser scroll bar style ::...

Detailed explanation of table return and index coverage examples in MySQL

Table of contents Index Type Index structure Nonc...

Example method of viewing IP in Linux

Knowing the IP address of a device is important w...

Detailed explanation of Nginx status monitoring and log analysis

1. Nginx status monitoring Nginx provides a built...

Example code of vue custom component to implement v-model two-way binding data

In the project, you will encounter custom public ...

How MySQL supports billions of traffic

Table of contents 1 Master-slave read-write separ...

The pitfall record of case when judging NULL value in MySQL

Table of contents Preface Mysql case when syntax:...

【HTML element】How to embed images

The img element allows us to embed images in HTML...

WeChat applet uses canvas to draw clocks

This article shares the specific code of using ca...

CSS method of clearing float and BFC

BFC BFC: Block Formatting Context BFC layout rule...