Read my.cnf file

If we want to read an option group within a my.cnf config file for MySQL, then we can do so as follows;

my_print_defaults --config-file=/etc/mysql/my.cnf mysqld2

in the above example, we will read from the file /etc/mysql/my.cnf all values under the group mysql2

If we use the --config-file only, then only this file will be read.

 

The following works quite well;

my_print_defaults mysqld1

this will read from all configuration files (assuming they are included), where mysqld1 is the group