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

uniapp Sample code for implementing global sharing of WeChat mini-programs

Table of contents Create a global shared content ...

Introduction to version management tool Rational ClearCase

Rational ClearCase is a software configuration ma...

Detailed discussion of the character order of mysql order by in (recommended)

//MySQL statement SELECT * FROM `MyTable` WHERE `...

Detailed explanation of Javascript basics loop

Table of contents cycle for for-in for-of while d...

MySQL full-text search usage examples

Table of contents 1. Environmental Preparation 2....

MySQL 8.0.14 installation and configuration method graphic tutorial

This article records the installation and configu...

Detailed explanation of the definition and function of delimiter in MySQL

When you first learn MySQL, you may not understan...

MySQL query method with multiple conditions

mysql query with multiple conditions Environment:...

Tutorial on using $attrs and $listeners in Vue

Table of contents introduce Example Summarize int...

jQuery plugin to achieve carousel effect

A jQuery plugin every day - jQuery plugin to impl...

Double loading issue when the page contains img src

<br />When the page contains <img src=&qu...

mysql5.7.17 installation and configuration example on win2008R2 64-bit system

123WORDPRESS.COM has explained to you the install...

How to set Nginx to forward the domain name to the specified port

Enter /usr/local/nginx/conf sudo cd /usr/local/ng...