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

SQL implementation LeetCode (176. Second highest salary)

[LeetCode] 176. Second Highest Salary Write a SQL...

JavaScript to achieve full screen page scrolling effect

After I finished reading JavaScript DOM, I had a ...

Mysql NULL caused the pit

Using NULL in comparison operators mysql> sele...

Mini Programs enable product attribute selection or specification selection

This article shares the specific code for impleme...

Continuous delivery using Jenkins and Docker under Docker

1. What is Continuous Delivery The software produ...

Who is a User Experience Designer?

Scary, isn't it! Translation in the picture: ...

Example of asynchronous file upload in html

Copy code The code is as follows: <form action...

Detailed explanation of reduce fold unfold usage in JS

Table of contents fold (reduce) Using for...of Us...

MySQL sql_mode analysis and setting explanation

When inserting a set of data into the MySQL datab...

How to use Web front-end vector icons

Preface When writing front-end pages, we often us...

Solution to Mysql binlog log file being too large

Table of contents 1. Related binlog configuration...

Native JS to achieve draggable login box

This article shares a draggable login box impleme...

How to reduce the root directory of XFS partition format in Linux

Table of contents Preface System environment Curr...

Example sharing of anchor tag usage in HTML

Anchor tag usage: Linking to a specific location i...