MySQL 8.0 Database Administrator — Question 105

A user wants to connect without entering his or her username and password on the Linux command prompt.
Which three locations can be used to store the user’s mysql credentials to satisfy this requirement? (Choose three.)

Answer options

• A. $HOME/.my.cnf file
• B. $MYSQL_HOME/my.cnf file
• C. DATADIR/mysqld-auto.cnf file
• D. $HOME/.mylogin.cnf file
• E. $HOME/.mysql/auth/login file
• F. /etc/my.cnf file
• G. $HOME/.mysqlrc file

Correct answer: B, C, F

Explanation

The correct answers are B, C, and F because these files are valid locations for storing MySQL credentials, allowing users to log in without manually entering their credentials. Options A, D, E, and G are not typically used for this purpose or do not meet the requirement for credential storage in this context.