MySQL 8 Administrator???s Guide

Modifying options with files

Most of the MySQL programs can read startup options from the option files, also sometimes called configuration files. It is a very convenient way of providing the options that are commonly used and once specified you need not specify them each time you execute the program. To check whether the program reads option files, use the --help option. For example, consider the mysqld program, which should use --verbose and --help, if it reads option files. The help message will indicate which option file it looks for and for which option group:

The MySQL program with the --no-defualts option does not read any option files apart from .mylogin.cnf. If the server program started with the option persisted_globals_load system ...