nerdexam
Oracle

1Z0-908 · Question #15

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…

The correct answer is B. $MYSQL_HOME/my.cnf file C. DATADIR/mysqld-auto.cnf file F. /etc/my.cnf file. https://dev.mysql.com/doc/refman/8.0/en/option-files.html

Installation and Configuration

Question

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.)

Options

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

How the community answered

(27 responses)
  • B
    93% (25)
  • D
    4% (1)
  • G
    4% (1)

Explanation

https://dev.mysql.com/doc/refman/8.0/en/option-files.html

Topics

#option files#credential storage#.my.cnf#MySQL configuration files

Community Discussion

No community discussion yet for this question.

Full 1Z0-908 Practice