How to find the my.ini configuration file in MySQL 5.6 under Windows

How to find the my.ini configuration file in MySQL 5.6 under Windows

Make a note so you can come back and check it later if you forget.

Problem description:

Today I need to modify the MySQL configuration file for a small experiment. MySQL5.6 is installed on my computer. Because it has been installed for a long time, I forgot which directory it was installed in, so I first checked the directory location of MySQL installed on this computer.

Log in to MySQL in the DOS command line window and enter the following command to view the MySQL installation directory and data storage directory. The MySQL configuration file is in the data storage directory:

Another method:

Find the MySQL command line client tool under "Start → All Programs → MySQL", right-click the command line tool to view "Properties", and you can also see the location of the configuration file used by MySQL in "Target".

Note: The ProgramData directory may be "hidden". If you cannot see it in the displayed partition, modify the system settings to make hidden files/folders visible. Alternatively, you can directly copy the ProgramData/MySQL/MySQL Server 5.6 directory and paste it directly into the folder's directory window.

The above method of finding the my.ini configuration file in MySQL 5.6 under Windows is all the content that the editor shares with you. I hope it can give you a reference. I also hope that you will support 123WORDPRESS.COM.

You may also be interested in:
  • Modify the maximum number of mysql connections and configuration files in docker
  • Tutorial on integrating MySQL with springboot's yml configuration file through db2
  • IDEA uses properties configuration file to connect to MySQL database
  • How to modify the mysql configuration file under docker
  • How to configure the My.ini file when installing MySQL5.6.17 database
  • MySql 5.7.20 installation and configuration of data and my.ini files
  • Mysql file configuration analysis

<<:  Vue Element front-end application development to obtain back-end data

>>:  In-depth analysis of nginx+php-fpm service HTTP status code 502

Recommend

Detailed explanation of querying JSON format fields in MySQL

During the work development process, a requiremen...

How to implement simple data monitoring with JS

Table of contents Overview first step Step 2 Why ...

VMWare15 installs Mac OS system (graphic tutorial)

Installation Environment WIN10 VMware Workstation...

Html Select uses the selected attribute to set the default selection

Adding the attribute selected = "selected&quo...

MySQL query example explanation through instantiated object parameters

This article will introduce how to query data in ...

Summary on Positioning in CSS

There are four types of positioning in CSS, which...

Docker uses the Prune command to clean up the none image

Table of contents The creation and confusion of n...

Remote Desktop Connection between Windows and Linux

When it comes to remote desktop connection to Lin...

Solution to index failure in MySQL due to different field character sets

What is an index? Why create an index? Indexes ar...

MySQL 8.0.19 installation and configuration method graphic tutorial

This article records the installation and configu...

Detailed explanation of html download function

The new project has basically come to an end. It ...

Detailed steps for setting up a nexus server

1. The significance of building nexus service As ...