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?
A.
Use the AES_ENCRYPT() MySQL function on the option file.
B.
Use mysql_secure_installation to encrypt stored login credentials.
C.
Use a text editor to create a new defaults file and encrypt it from Linux prompt.
D.
Use mysql_config_editor to create an encrypted file.
The best way to encrypt the file is to use mysql_config_editor to create an encrypted file. This utility encrypts the .mylogin.cnf file which contains the login credentials. The other options do not provide the necessary encryption for a file stored on a local file system. So, the correct answer is D. Use mysql_config_editor to create an encrypted file.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
FelipeK
2 months, 4 weeks agomarklv
3 months, 2 weeks ago