Where is the my.cnf configuration file?

The my.cnf configuration file is located under the path "/etc/my.cnf" on Linux and under the root directory of the installation directory on Windows; you can use the command "mysql --help" to view the information. MYSQL corresponding configuration file "my.cnf" search order.

Generally, it is placed in /etc/my.cnf on Linux. It is installed by default on window. It may not be found according to the above path. You can log in on window. Go to mysql and use show variables like '�ta%' to first find the data storage path. Generally, my.ini is at the upper level of the data file.

The one under win is my.ini, which is usually in the root directory of the installation directory.

Example:

Method on Windows 7 computer.

1) Find MySQL Notifier from the taskbar, right-click, select "SQL Editor" to open

2) You can see that MySQL Workbench is opened, select Options File from the Navigator on the left sidebar; If there is no Navigator on the left, select the option to show the left sidebar in the upper right corner.

3) You can see the location of the Configuration File in the lower part of the Workbench, which is the path to my.ini.

Recommended: "mysql tutorial"

Extended information:

Use mysql --help to view about MYSQL Corresponding to the search order of the configuration file my.cnf, this command is used to view on both Windows and Linux; on Linux, you can use mysql --help|grep my.cnf to filter and view.

The above is the detailed content of Where is the my.cnf configuration file?. For more information, please follow other related articles on the PHP Chinese website!