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

Implementing a simple Gobang game with native JavaScript

This article shares the specific code for impleme...

How to use union all in MySQL to get the union sort

Sometimes in a project, due to some irreversible ...

Windows DNS server exposed "worm-level" vulnerability, has existed for 17 years

Vulnerability Introduction The SigRed vulnerabili...

Solution for Docker container not recognizing fonts such as Songti

Problem background: When using docker to deploy t...

3 common errors in reading MySQL Binlog logs

1. mysqlbinlog: [ERROR] unknown variable 'def...

Docker installation tutorial in Linux environment

1. Installation environment Docker supports the f...

Call and execute host docker operations in docker container

First of all, this post is dedicated to Docker no...

Implementation method of Mysql tree recursive query

Preface For tree-structured data in the database,...

MySQL 8.0 upgrade experience

Table of contents Preface 1. First completely uni...

How to implement Mysql scheduled tasks under Linux

Assumption: The stored procedure is executed ever...

Implementation of ssh non-secret communication in linux

What is ssh Administrators can log in remotely to...

Solution to VMware virtual machine no network

Table of contents 1. Problem Description 2. Probl...

SSM VUE Axios Detailed Explanation

Table of contents How to display SQL log? ? Descr...