Shulou(Shulou.com)05/31 Report--

This article mainly explains the "mysql to find configuration file my.ini location method", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's train of thought slowly in depth, together to study and learn "mysql to find configuration file my.ini location method"!

Personal remarks: when the file type is not displayed, the my.ini file name is called my, and the file properties show ini.

Find the my file and see the properties to see if it is my.ini.

Problem description:

Today to do a small experiment need to modify the configuration file of MySQL, my computer is installed MySQL5.6, because the installation time is too long to forget which directory to install, so first check the directory location of MySQL installed on this machine.

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

Another way:

Under "start → all programs → MySQL", find MySQL's command line client tool, right-select the command line tool to view "Properties", and you can also see the configuration file location used by MySQL in "Target".

Note: the ProgramData directory may be "hidden". If you can't see it in the displayed partition, modify the system settings so that hidden files / folders are visible. Or you can just copy down the ProgramData/MySQL/MySQL Server 5.6 directory and paste it into the folder's directory window.

-I am the dividing line

The first step is to find the installation path of mysql on our computer and click in.

After the second step, you can see that my.ini is in the root directory of the mysql installation path, which is one of the cases.

Step 3 another situation is that we cannot find the my-default.ini file in the mysql installation directory and see the my-default.ini file. At this time, my.ini is under the "C:\ ProgramData\ MySQL\ MySQL Server 5.6" directory. We first need to find the ProgramData folder, which is a hidden file that needs to be visible or can be retrieved directly.

In step 4, we can see that the my.ini file is found in the "C:\ ProgramData\ MySQL\ MySQL Server 5.6" directory.

Thank you for your reading, the above is the content of "mysql to find the location of the configuration file my.ini", after the study of this article, I believe you have a deeper understanding of the method of finding the location of the configuration file my.ini by mysql, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.