Graphical analysis of MYSQL5.7 configuration file location in Windows environment

Graphical analysis of MYSQL5.7 configuration file location in Windows environment

1. MYSQL installation directory

Copy the code as follows:
select @@basedir;

2. MYSQL data file directory

Copy the code as follows:
select @@datadir;

3. Accordingly, the configuration file is in the directory above the data file

4. Stop MYSQL service

Copy the code as follows:
net stop 本機mysql服務名

5. Start the MYSQL service

Copy the code as follows:
net start 本機mysql服務名

6. Configuration parameter max_allowed_packet

The maximum size of the buffer for communication between client and server. The default is 4M.

7. Configuration parameter net_buffer_length

TCP/IP and socket communication buffer size, create lines up to net_buffer_length , default is 1M

Summarize

The above is the graphic analysis of MYSQL5.7 configuration file location in Windows environment 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!
If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!

You may also be interested in:
  • Solve the problems encountered when installing mysql-8.0.11-winx64 in Windows environment
  • MySQL installation tutorial under Windows with pictures and text
  • How to generate random numbers with specified digits in MySQL and how to generate random numbers in batches
  • MySQL performance bottleneck troubleshooting and location example
  • Sharing the location and repair process of the mysql connection failure problem

<<:  How to solve nginx 503 Service Temporarily Unavailable

>>:  How to solve the problem of automatic package update in Debian system

Recommend

ElementUI implements sample code for drop-down options and multiple-select boxes

Table of contents Drop-down multiple-select box U...

jQuery plugin to implement dashboard

The jquery plug-in implements the dashboard for y...

Detailed explanation of the principle of Vue monitoring data

Table of contents 1. Introduction II. Monitoring ...

Summary of the differences between global objects in nodejs and browsers

In Node.js, a .js file is a complete scope (modul...

Tutorial on using hyperlink tags in XHTML

Hyperlink, also called "link". Hyperlin...

Customization Method of Linux Peripheral File System

Preface Generally speaking, when we talk about Li...

4 flexible Scss compilation output styles

Many people have been told how to compile from th...

Implementation of Redis master-slave cluster based on Docker

Table of contents 1. Pull the Redis image 2. Crea...

Vue.js implements simple timer function

This article example shares the specific code of ...

In-depth understanding of MySQL global locks and table locks

Preface According to the scope of locking, locks ...

How to share Flash pages through verification methods in website standards

1. Embed is illegal The <embed> tag is a pri...

Detailed explanation of real-time backup knowledge points of MySQL database

Preface The need for real-time database backup is...

Table td picture horizontally and vertically centered code

Html code: Copy code The code is as follows: <t...

Window environment configuration Mysql 5.7.21 windowx64.zip free installation version tutorial detailed explanation

1. Download mysql-5.7.21-windowx64.zip from the o...

mysql5.7.14 decompression version installation and configuration method graphic tutorial (win10)

Win10 installs mysql5.7 decompressed version, for...