Oracle
1Z0-908 · Question #8
You wish to store the username and password for a client connection to MySQL server in a file on a local file system. Which is the best way to encrypt the file?
The correct answer is D. Use mysql_config_editor to create an encrypted file. https://dev.mysql.com/doc/mysql-security-excerpt/5.7/en/password-security-user.html
Security
Question
You wish to store the username and password for a client connection to MySQL server in a file on a local file system. Which is the best way to encrypt the file?
Options
- AUse the AES_ENCRYPT() MySQL function on the option file.
- BUse mysql_secure_installation to encrypt stored login credentials.
- CUse a text editor to create a new defaults file and encrypt it from Linux prompt.
- DUse mysql_config_editor to create an encrypted file.
How the community answered
(24 responses)- C4% (1)
- D96% (23)
Explanation
https://dev.mysql.com/doc/mysql-security-excerpt/5.7/en/password-security-user.html
Topics
#mysql_config_editor#credential storage#.mylogin.cnf#option file encryption
Community Discussion
No community discussion yet for this question.