Location of MySQL configuration file My.ini or my.cnf

1. The configuration file for MySQL under Windows is My.ini, which is usually in the root directory of the installation directory.

2, Linux under the MySQL configuration file is my.cnf, will generally put in/etc/my.cnf,/etc/mysql/my.cnf. If you can't find it, you can find it with the Find command.

3, Linux with RPM package installed MySQL will not install the/etc/my.cnf file

As for why there is no such file and MySQL can start and function normally, there are two statements:
The first argument, MY.CNF is only a mysql startup parameter file, can not have it, then MySQL will use the built-in default parameters to start;
The second argument is that MySQL automatically uses the my-medium.cnf file in the/usr/share/mysql directory at startup, which is limited to the RPM package installed by MySQL.

Workaround: Simply copy the. cnf file from the/usr/share/mysql directory to the/etc directory and rename it to MY.CNF

3rd original link: http://blog.csdn.net/newb921/article/details/5178011

Location of MySQL configuration file My.ini or my.cnf