MySQL 8.0 Database Administrator — Question 39

MySQL programs look for option files in standard locations.
Which method will show the option files and the order in which they are read?

Answer options

• A. shell> mysqladmin --debug
• B. shell> mysql --print-defaults
• C. shell> mysqld --help --verbose
• D. mysql> SHOW GLOBAL VARIABLES;

Correct answer: A

Explanation

The correct answer is A because the 'mysqladmin --debug' command provides detailed information about option files and their reading order. Options B and C provide different types of information about defaults and server help, while D retrieves global variables but does not address option file locations.