{"id":12752,"date":"2023-12-08T05:44:27","date_gmt":"2023-12-08T12:44:27","guid":{"rendered":"https:\/\/www.mysqltutorial.org\/?page_id=12752"},"modified":"2023-12-21T20:27:55","modified_gmt":"2023-12-22T03:27:55","slug":"mysql-configuration-file","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-administration\/mysql-configuration-file\/","title":{"rendered":"MySQL Configuration File"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will explore the MySQL configuration file, discover its location, and understand its structure.<\/p>\n\n\n\n

Introduction to MySQL configuration file<\/h2>\n\n\n\n

MySQL programs such as mysqld<\/a>, mysqladmin<\/a>, mysqldump<\/a>, and so on offer a convenient way to configure and manage commonly used options through option files, also known as configuration files<\/strong>.<\/p>\n\n\n\n

The configuration files allow you to avoid entering command line options every time you execute a program.<\/p>\n\n\n\n

Checking if a MySQL program reads the option files<\/h2>\n\n\n\n

To determine whether a MySQL program reads the configuration file, you follow these steps:<\/p>\n\n\n\n

First, open the Terminal.<\/p>\n\n\n\n

Second, execute the following command:<\/p>\n\n\n

program --verbose --help<\/code><\/span><\/pre>\n\n\n
For example, you can use the following command to check which configuration file the mysqld<\/code> program uses:<\/p>\n\n\n
mysqld --verbose --help<\/code><\/span><\/pre>\n\n\n
If the mysqld<\/code> reads configuration files, the help message will indicate which files it looks for and which option groups it recognizes.<\/p>\n\n\n\n
Since the command returns a very long output, on Linux and macOS, you can use the less<\/code> command to show the first page:<\/p>\n\n\n
mysqld --verbose --help | less<\/code><\/span><\/pre>\n\n\n
On Windows, you can use the more command:<\/p>\n\n\n
mysqld --verbose --help | more<\/code><\/span><\/pre>\n\n\n
Note that to escape the output, you press the letter q<\/code>.<\/p>\n\n\n\n
Here’s the extracted output that is relevant to the configuration file and section groups:<\/p>\n\n\n
\nDefault<\/span> options are read from the following files in the given order:\n\/etc\/my.cnf \/etc\/mysql\/my.cnf ~\/.my.cnf\nThe following groups are read: mysql client<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
MySQL configuration file processing order<\/h2>\n\n\n\n
The output shows that the mysqld<\/code> program reads the configuration file in the following order:<\/p>\n\n\n
\/etc\/my.cnf\n\/etc\/mysql\/my.cnf\n~\/.my.cnf<\/code><\/span><\/pre>\n\n\n
If multiple files exist, the mysqld<\/code> will read all of them in the order. The order of reading option files is important because options specified later can override options specified earlier.<\/p>\n\n\n\n
Also, the output mentioned that the mysqld will read two sections: mysql<\/code> and client<\/code>. In other words, it will read the parameters in the [mysq]<\/code> and [client]<\/code> sections.<\/p>\n\n\n\n
On Windows <\/h3>\n\n\n\n
MySQL programs read startup options from the following files in the specified order:<\/p>\n\n\n\n